topic adding extra column in Pivot Table in QlikView

adding extra column in Pivot Table

prma7799 — Wed, 21 Mar 2018 07:59:13 GMT

Dear All,

PFA.. in that i have pivot table with one expression and three dimension now I want to add two expression as I mention in attachment.

PrashantSangle — Wed, 21 Mar 2018 09:45:43 GMT

can you show what is your expected output..??

REgards,

prma7799 — Wed, 21 Mar 2018 09:55:26 GMT

Hi Prashant,

PFA for expected output.

I want shipped qty bifurcate with shipped months

sunny_talwar — Wed, 21 Mar 2018 10:05:15 GMT

You can do it in the attached way

prma7799 — Wed, 21 Mar 2018 10:25:34 GMT

Really thanks for your reply ....

can you please explain how it works ...

and what should i do if i want output like below ....

sunny_talwar — Wed, 21 Mar 2018 10:33:41 GMT

Change the order of your dimension and also sort Ship Month on an expression Only({1} Dim)