Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a pivot table in my application and have 3-4 dimensions with an expression in it.
now what i want is ,i want to show one dimension at the end means i want that dimension column to come at the end of my pivot table after the expression. how can i do that?
and is it possible to have dimension after expression by any hook or crook.
thanks
sudhanshu shrivas
Can do it with straight table but pivot.
hi,
In straight it is possible..but i have to use pivot table.anyway through which i can get the demension at the end.
thanks
In pivot table if you drag the column it becomes visible horizontal on the top.
As tresesco remarked the vertical column presentation of the dimension after an expression is possible using only st table.
Pivot is to represent hierarchical view of dimension association. If you think of taking one dimension at the end - the purpose of pivot seems to be broken. This makes sense to not allow the dimension movement the way you want.
Hi,
For example: You can move to the first position an expression in a straight table. No in a Pivot Table.
Pivot Table needs first the dimensions.
Regards,
not a best practice but is possible if you use two copies of the same pivot table one with bottom layout and another one top layout like below.
you can change the text and background color of one dimension in one table and the other dimension in another table.
but this will fail if you have scroll bars means lots of data as the scrolling in one table will not scroll in another one.
My suggestion is to accept the visualization objects behavior as they are designed and explain the clients about it.
See this:
http://community.qlik.com/message/574280#574280
But I recommend you to use Straight Table.
Regards
Aviral Nag