Expression not working

[bhaveshp90]

Hello, 

I have a table as shown below

I am calculating Current - Dec = (Current Month POC - Last Year December month POC)

Eg: for January-2018, 28.30-19.90 = 8.4, for February-2018, 39.40-19.90 = 19.5.

But My Values are wrong as highlighted in the above image. 

What is wrong with my expression here? Attached is the file for reference

Sum(POC)
-
Sum({<Num_Month = {'$(vPreYearLastMonth)'},Year = {'$(vPreYear)'}>}POC)

thanks

Bhavesh

[bhaveshp90]

thank you @sunny_talwar, please look into the attached file; 

[sunny_talwar · Accepted solution]

Try this

Sum(POC) - Above(TOTAL Sum(POC), Num(Month))

I think your values for Jan, Feb, Mar are not right.... they should be 0, 0, and 0, right because you have 100-100 for all three months of 2018

[bhaveshp90]

Awesome @sunny_talwar, thank you 

-you are right, it was a typo error

[bhaveshp90]

@sunny_talwar the expression is null when selecting Month field, it is showing correct values when no month is selected. 

Since, this post is closed Please look into the link below, thanks

https://community.qlik.com/t5/New-to-QlikView/Expression-is-showing-null-when-selecting-the-Month-fi...