Solved: adding extra column in Pivot Table - Qlik Community

prma7799 · ‎2018-03-21

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.

sunny_talwar · ‎2018-03-21

You can do it in the attached way

View solution in original post

PrashantSangle · ‎2018-03-21

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

REgards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

prma7799 · ‎2018-03-21

Hi Prashant,

PFA for expected output.

I want shipped qty bifurcate with shipped months

sunny_talwar · ‎2018-03-21

You can do it in the attached way

prma7799 · ‎2018-03-21

Hi stalwar1‌ ,

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 · ‎2018-03-21

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