ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: resolvecomputing on April 03, 2018, 04:35:24 pm

Title: Error in pivot?
Post by: resolvecomputing on April 03, 2018, 04:35:24 pm

when we use one dimension and one aggregate the other dimensions are shown as empty columns. The users feel that this should not be displayed and is an error. can we suppress the unwanted dimensions when only one dimension is chosen? if so, how can we do it?

Title: Re: Error in pivot?
Post by: paramvir on April 03, 2018, 06:57:18 pm

Unwanted panes / dimensions can be hidden in toolPanel by toolPanel configuration sub-options.

https://paramquery.com/pro/api#option-toolPanel

Title: Re: Error in pivot?
Post by: resolvecomputing on April 04, 2018, 09:03:22 am

I mean, I didn't choose Group column, so how can I hide other columns in table without aggregate column?
Thanks.

Title: Re: Error in pivot?
Post by: paramvir on April 04, 2018, 10:58:13 pm

Columns can be hidden in toolPanel with tpHide property.

https://paramquery.com/pro/api#option-column-tpHide

Title: Re: Error in pivot?
Post by: resolvecomputing on April 05, 2018, 06:48:49 am

Even if I use tpHide the column is hidden in the panel but the column itself appears as an empty column. see the illustration attached.

Title: Re: Error in pivot?
Post by: paramvir on April 05, 2018, 09:56:08 am

As mentioned earlier and in the documentation, tpHide is used to hide a column in toolPanel.

To hide a column in the grid, use column.hidden property.