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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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