Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
bhaveshp90
Contributor III

Expression is showing null when selecting the Month field

Hello, 

The Expression Current-Dec POC is becoming null when selecting the Month field, without selecting it is showing correct values but when selected any month the expression becomes null. 1.PNG

 

 

 

 

 

 

 

 

1.PNG

 

 

 

 

My Expression for Current-Dec POC is 

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

Attached is the file for reference. 

thanks

Bhavesh

Labels (2)
1 Solution

Accepted Solutions
bhaveshp90
Contributor III

Re: Expression is showing null when selecting the Month field

This expression is now working by adding MonthYear in the Set Analysis, thank you @sunny_talwar

Sum(POC)
-
Above(TOTAL Sum({<MonthYear>}POC), Num(Month))

 

View solution in original post

1 Reply
bhaveshp90
Contributor III

Re: Expression is showing null when selecting the Month field

This expression is now working by adding MonthYear in the Set Analysis, thank you @sunny_talwar

Sum(POC)
-
Above(TOTAL Sum({<MonthYear>}POC), Num(Month))

 

View solution in original post