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: 
chiru_thota
Specialist
Specialist

Dimension order in the report when we use conditional hide & Show

Dear Developers,

We are using Conditional Hide and Show feature for enabling dimensions in our report.It is working fine.

But the Dimension order is always coming in the report dimension order even though I select different order from list box. .

Report Dimension Order :

Dim2.png

Report :

Grid.png

My requirement is to get the dimension in list box selected order in to the grid.

For example if I select Dim3 first ,then Dim5 and then Dim1 from Choose Dimension list box.Report should show as below

Dim.png

Is this possible in Qlikview ?

I am also attaching sample application.

Thanks,

Chiru.

1 Reply
Anonymous
Not applicable

Chiru,

QlikView "doesn't know" in what order the selections were made.  It only "knows" what is selected.  That is, the first answer - not possible.

The second answer...  It may be possible if create a variable which is controlled by a macro, so each time the selections are made, the values are added to the variable.  As a result, the variable contains a list of values in the order they were selected.  Next, use it somehow in the chart.  If you want to try it - please share the results.

Regards,

Michael