Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

Pivot table

Hi,

im calculating weekly differences in pivot table expression and useing below exp

if(sum(T1)>0,before(sum(T1)))-if(sum(T1)>0,sum(T1))

it creates one more  expression  with 0  value can any suggest how i can avoid  extra cols

Thanks

2 Replies
Not applicable

I don't understand your english

srinivasa1
Creator II
Creator II
Author

Hi Ricardo.Sorry type.i have updated my query.