topic need help with pivot chart in QlikView

need help with pivot chart

Thu, 24 Jul 2014 09:02:04 GMT

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

Re: need help with pivot chart

tresB — Thu, 24 Jul 2014 09:05:06 GMT

Can do it with straight table but pivot.

Re: need help with pivot chart

Thu, 24 Jul 2014 09:08:56 GMT

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

Re: need help with pivot chart

sudeepkm — Thu, 24 Jul 2014 09:12:03 GMT

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.

Re: need help with pivot chart

tresB — Thu, 24 Jul 2014 09:13:37 GMT

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.

Re: need help with pivot chart

sorrakis01 — Thu, 24 Jul 2014 09:18:46 GMT

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,

Re: need help with pivot chart

sudeepkm — Thu, 24 Jul 2014 09:25:40 GMT

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.

Re: need help with pivot chart

aveeeeeee7en — Thu, 24 Jul 2014 10:17:54 GMT

See this:

http://community.qlik.com/message/574280#574280

But I recommend you to use Straight Table.

Regards

Aviral Nag