topic Re: Null value handling in QlikView

Null value handling

vinod_r — Wed, 10 Feb 2021 18:30:11 GMT

I have requirement of calculating Previous Year revenue with current year FX Please see attachments for Problem and Reuired Solution

- Final Amount should be converted into EUR with latest Year FX

- All selection combination must be possible after calculation

Looking forward for solution 🙂

Re: Null value handling

MayilVahanan — Thu, 11 Feb 2021 04:50:17 GMT

Hi @vinod_r

One of the way to achieve the result.. Please verify

Re: Null value handling

vinod_r — Thu, 11 Feb 2021 05:30:58 GMT

Thanks MayilVahanan,

But that doesn't full fill the condition of "Should be able to filter all values in the Mulitibox shown in the app " . Region Code 8235 is not selectable in your solution

Regards

vinod_r

Re: Null value handling

MayilVahanan — Thu, 11 Feb 2021 05:58:04 GMT

HI @vinod_r

Its not in source itself.

If you want to generate the missed data, try like attachment, it will generate all missed info from txn table.

Re: Null value handling

vinod_r — Mon, 15 Feb 2021 08:32:07 GMT

Got it..!!!

Thanks a lot @MayilVahanan