Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator 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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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))