topic Re: Adhoc conditional dimensions sorting in pivot table in QlikView

Adhoc conditional dimensions sorting in pivot table

venkat1 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Adhoc conditional dimensions sorting in pivot table

asinha1991 — Tue, 17 Sep 2019 16:16:57 GMT

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))]

Re: Adhoc conditional dimensions sorting in pivot table

venkat1 — Wed, 18 Sep 2019 10:55:49 GMT

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