Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Adhoc conditional dimensions sorting in pivot table

Hello all

Can anyone tell me how to change the order for dimensions dynamically in adhoc reporting .

I am having a list box (_dimensions) and values for _dimensions are A,B,C,D,E,F

and i am having a pivot table 

now if i select _dimensions A,b,c,d,.... values those will come in pivot table according to the order i added in pivot table,now my question is can we make the dimensions order  by user selection in pivot table?
i.e.. if i select B,C,A then the dimension order should be in such a way how user is selecting.

please help me if anyone know about this. 

1 Solution

Accepted Solutions
Highlighted
Contributor II

Re: Adhoc conditional dimensions sorting in pivot table

My requirement is fulfilled with drag and drop dimensions with in pivot table 

View solution in original post

2 Replies
Highlighted
Contributor III

Re: Adhoc conditional dimensions sorting in pivot table

make all three dimension calculated something like this

if your _dimension contain values like A,B,C    B,C,A   AND C,B,A

make your dimensions as below

1st dimension $[(=left(_dimension,1))]

2nd dimension  $[(=left(_dimension,3))]

3rd dimension   $[(=left(_dimension,5))]

Highlighted
Contributor II

Re: Adhoc conditional dimensions sorting in pivot table

My requirement is fulfilled with drag and drop dimensions with in pivot table 

View solution in original post