Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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

Specialist
Specialist

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.

Contributor
Contributor

Thank you soo much ..