Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

add calculated column to pivot table

Hi,

I need to create table:

Capture.PNG

I created all except from third column. I am not able to make it look this way. how to I add the third column to my table? I have the calculation for each row in this column but where to put them? If I put in dimension it is adding it to the wrong place or not adding at all (the Plan/Target PTDS etc...)

please help.

thanks,

Anat

4 Replies
Highlighted

Re: add calculated column to pivot table

When you say third column, It has to be Expression section only. Then Transpose Month to Row from Column ..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III
Contributor III

Re: add calculated column to pivot table

how do I Transpose Month to Row from Column ?

Highlighted

Re: add calculated column to pivot table

I believe this is from Pivot Table? So, By using Month Field and Drag to Row level on top of expressions it will cross and shows Blue wiggly line. So, you just place overthere it self..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III
Contributor III

Re: add calculated column to pivot table

if you have sample data,maybe I can try it.