If Null expression

Stickman — Sat, 16 Nov 2024 02:55:31 GMT

Hi everyone - looking to get some help with this expression

What I'm trying to show is a value of the vMaxSelectedDate calculation if the first calculation shows a null.

The first calculation takes the last day of the month

The second calculation takes the last selected day of the month.

I hope the below expression is clear for you to read. Please let me know if there are any questions.

=if((sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}dcMonthlyRate*Occ_Flag)
/
sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}Occ_Flag)) <=0,

(sum({$<Date={'$(vMaxSelectedDate)'}>}dcMonthlyRate*Occ_Flag)
/
sum({$<FactTypeID={1},bRentable={Y},Date={'$(vMaxSelectedDate)'}>}Occ_Flag)),

(sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}dcMonthlyRate*Occ_Flag)
/
sum({$<LAST_WORKING_DAY_MONTH={1},FactTypeID={1},bRentable={Y}>}Occ_Flag)))

The result I get shows the months up to the last selected month, at which point it shows a null value.

Re: If Null expression

Brett_Bleess — Wed, 14 Aug 2019 21:41:45 GMT

It will likely help if you can attach the qvw file or a sample one with the data model etc. as well. This generally makes it easier for folks to help, as they can look everything over to be sure they are providing the correct solution...

Regards,
Brett

topic If Null expression in QlikView

If Null expression

Re: If Null expression