Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
giuliascial
Partner - Contributor
Partner - Contributor

Pivot column based on condition and how change the global totals

Hello, I am new in Qliksense. I have a problem with a pivot table.  I would like to change this table based on condition: if [Real Cost] > 0 then Invoice (USA + ITA) else Invoice(USA + ITA) = 0.  I would like that the Totals changes without counting the number 2000. Is it possibile to do something like that? I tried to do this; I calculated the Invoice (USA + ITA) column with this condition: =if([Real Cost] <> 0, [Invoice (USA + ITA)], 0) this works fine but the totals are still the same. How can I resolve this kind of problems? Thanks Immaginexx.png

0 Replies