topic Re: Condition showing dimensions in Pivot table view in QlikView

Self service Report of Conditional showing dimensions issue in Pivot table view

mahesh_m1029488 — Mon, 13 Mar 2017 10:55:17 GMT

Hi ,

I have created a Pivot table of self service report , where the user can select any number of dimensions from a list box and also metrics .

The chart will load dynamically.

Here the problem is the number of dimension & metrics are conditionally working upto 6 max.

But if there is no conditions we can see all the dim & metrics as all of you know

My client wanted to have all selection view . But when ever the dimension selection is crossing 6 max , the pivot chart automatically minimizing to one cell.

Please help if there is any option ?

Re: Condition showing dimensions in Pivot table view

udaya_kumar — Mon, 13 Mar 2017 11:47:06 GMT

I think you are using GetFieldSelections() function to get the dimension values and show and hide the dimensions based on that.

If yes, then please use the below expression

Your expression (I think so)

GetFieldSelections(Dimension)

New expression (Use this one instead of above expression)

GetFieldSelections(Dimension,',',100)

Try this and let us know.

Re: Condition showing dimensions in Pivot table view

Anonymous — Mon, 13 Mar 2017 11:55:08 GMT

Uday Kumar solution should work. By default, GetFieldSelections() function holds upto 6 values. If you want the function to hold more values, you can specify the max number of values like 100 as mentioned.

Re: Self service Report of Conditional showing dimensions issue in Pivot table view

mahesh_m1029488 — Mon, 13 Mar 2017 12:55:55 GMT

Thank you soo much ..