Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

MTD values are null when Month is selected

Hello, 

The Expression MTD is showing the correct value as shown in the below image. But when a Month field is selected it is becoming a null value. 

1.PNG

 

 

 

 

 

 

 

 

 

 

When September-2018 is selected, the value becomes null as shown below2.PNG

 

 

 

 

 

What I am missing in my MTD expression, attached is the file for reference. 

 

thanks

Bhavesh

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Change the 

Num(Month)

to

Num(Only({<MonthYear>}Month))

View solution in original post

2 Replies
sunny_talwar

Change the 

Num(Month)

to

Num(Only({<MonthYear>}Month))
bhaveshp90
Creator III
Creator III
Author

Awesome thank you @sunny_talwar