topic Re: MTD values are null when Month is selected in QlikView

MTD values are null when Month is selected

bhaveshp90 — Sat, 16 Nov 2024 04:28:00 GMT

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.

When September-2018 is selected, the value becomes null as shown below

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

thanks

Bhavesh

sunny_talwar — Wed, 13 Feb 2019 14:11:45 GMT

Change the

Num(Month)

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

bhaveshp90 — Wed, 13 Feb 2019 14:23:55 GMT

Awesome thank you @sunny_talwar