topic Pivot table in QlikView

Pivot table

Mon, 21 Oct 2013 05:26:22 GMT

Someone please help~~~

I have a pivot table which display the sales of customers for 2 different category of product (A and B).

Now I wants to add another column which display the Different between them (Just like the one in red box). What should I do??

er_mohit — Mon, 21 Oct 2013 05:32:05 GMT

simply write

column(1)-Column(2)

Mon, 21 Oct 2013 05:55:58 GMT

Hi Sharon,

If it is exactly 2 categories, then do the following

1. Add Date and Customer as Dimension in your Pivort Chart Object

2. Don't use Cateogry as Dimension, instead use it in expression as condition

3. Add first expression: Sum(If(Category='A',Sales))

4. Add secnod expression: Sum(If(Category='B',Sales))

5. Add third expression: Sum(If(category='A',Sales)) - Sum(If(Cateogry='B',Sales))

Mon, 21 Oct 2013 06:48:29 GMT

If I do this. it will look like this:

I don't think they will agree with this looks and feel..... so I must change the category Dimension in order to display the way the they wants....

I already updated my expression to handle the calculation. but I really dun know how to add the "Diff" in the dimension.....

Mon, 21 Oct 2013 06:56:08 GMT

Oh yes!!! you are correct... is the matter of pivoting~~~ thank you so much!!!!!

Mon, 21 Oct 2013 06:57:02 GMT

No, you can drag and drop the Customer dimension below expression header. Qlikview pivot table will allow you to do that