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: 
doespirito
Creator
Creator

wrong result on KPI

Hello,
I want to change the sign of negative amounts coming from SAP.
here is the data in excel

doespirito_4-1663150039184.png

I have a dimension in my data model that allows me to change the sign of REEL. So I created a measure

réalisé = sum({<NC_ND0={"R111_TVT"}>}REEL)*if(NC_ND1='A_TVT',-1,1)

It works fine in this table where NC_ND1 appears.

My problem is that when I use this measure in a KPI, changing the sign doesn't work.

doespirito_3-1663149438663.png

for me the expected amount is 1575261.17

does anyone have an idea?

Thank You

 

 

 

Labels (4)
0 Replies