topic Re: Logic needed for missing value in QlikView

Logic needed for missing value

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have two tables Table_A and TAble_B:

My current output is this:

There is no Category value for COUNTRY_B for EMPNO 240 for 5-Feb.

Required output:

I want to show for EMPNO 240 in 5-Feb.

Please help me.

Thanks in advance.

shiveshsingh — Tue, 13 Mar 2018 05:50:27 GMT

for your specific date, you can put calculated dimension.

=if(DATE = '2/5/2018' and IsNull(CATEGORY),'CATEGORY_B',CATEGORY)

Qrishna — Tue, 13 Mar 2018 06:11:32 GMT

Hi - i just reviewed your qvw and modified your script a bit to remove synthetic keys and duplicate fields.

also check out few comments in your script.

result: