Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add an additional column in pivot table.

We have a column in the Pivot table "TOTAL", which has both +ve and -ve values. Now we need an adjacent column which should only show +ve values from the TOTAL column and all the -ve values as 0.

Need help on how to do it.

3 Replies
MK_QSL
MVP
MVP

Can you share your sample apps?

May be we can achieve by using Dimensionality and Set Analysis.

manojkulkarni
Partner - Specialist II
Partner - Specialist II

you can copy the same column & then add conditional expression.

One with < 0

Other with > 0

Not applicable
Author

the TOTAL column is a a partial sum column. How to copy the same column ? Plz find below the screen shot pivot (2).png