Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahesh_m1029488
Contributor
Contributor

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

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 ?

Conditional dimensions limit issue.jpg

1 Solution

Accepted Solutions
udaya_kumar
Specialist
Specialist

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.

View solution in original post

3 Replies
udaya_kumar
Specialist
Specialist

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.

Anonymous
Not applicable

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.

mahesh_m1029488
Contributor
Contributor
Author

Thank you soo much ..