Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ndeeleysww
Contributor

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
Contributor II

Re: Display only negative values on a map

rangemin(

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

,

0)

Would make all +ve numbers 0.

ndeeleysww
Contributor

Re: Display only negative values on a map

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
Contributor

Re: Display only negative values on a map

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)

)