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

Display only negative values on a map

Hi there,

I've created a finance app. In the world of finance negative values display variance away from a set point (usually 0), so show values that are actually over budget. That's finance for you...

I'm showing variance to budget for sites in a point map using this set analysis. How do i display only the negative points, and remove the positive ones?

sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])

Thanks in advance!

Neil

3 Replies
sgrice
Partner - Creator II
Partner - Creator II

rangemin(

sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])

,

0)

Would make all +ve numbers 0.

ndeeleysww
Creator
Creator
Author

Hi Steven,

Thanks for the suggestion - it works very well. The only thing it doesn't do is remove the points which are not negative, which would be a lot clearer from a visual point of view. Is this possible?

Cheers

Neil

madhumitha
Creator
Creator

Hi Neil,

Try Using the below expression, with supress null values.

IF (

rangemin(

sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])

,

0) =0, null()

,

rangemin(

sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])

,

0)

)