Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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