ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: resolvecomputing on April 20, 2018, 12:21:08 pm

Title: Multiple filter in pivot
Post by: resolvecomputing on April 20, 2018, 12:21:08 pm

Can I make filter for multiple columns in pivot?

Title: Re: Multiple filter in pivot
Post by: paramvir on April 20, 2018, 03:13:36 pm

In case of pivot, multiple filtering can be done on primary columns only ( columns which are present in group rows pane ).

For example in this demo https://paramquery.com/pro/demos/pivot, only country column ( which is present in group rows ) can be filtered.

Title: Re: Multiple filter in pivot
Post by: resolvecomputing on April 24, 2018, 12:38:01 pm

Do paramquery have change event in pgSelect?

Title: Re: Multiple filter in pivot
Post by: paramvir on April 24, 2018, 11:48:51 pm

Yes there is change event in pqSelect which is used here:

https://paramquery.com/pro/demos/showhide_columns