Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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