Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, A question on qlikview table columns order.
I have a table consist of 4 dimensions and 7 expressions (5 expressions is hiden if unselected). Lets me be specific.
The 4 dimensions are D1,D2,D3,D4.
7 expressions are E1,E2...,E7.
E1,E2,E3,E4,E5 can be hiden if the user unselected. The user want the table column order like this.
_______________________________
E1,E2,E3,E4,E5,D1,D2,D3,D4,E6,E7.
If the user selected E1,E2,E3, the user want the table like this.
_______________________________
E1,E2,E3,D1,D2,D3,D4,E6,E7.
But the table will be like below in qllikview
_______________________________
E1,E2,E3,E6,E7,D1,D2,D3,D4
Anyone have idea to fix this.
Hello,
I tried to reproduce this, and yes whatever you are seeing right now is what i got.
The whole thing is to fix the positions of E6 and E7.
are these complex expressions? can they be moved to dimensions section?
Hi,
It is very difficult to set order but you can try the selection order by using =GetFieldSelections function and manage your column order.
Hope this helps
Thanks & Regards