Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
arethaking
Creator II
Creator II

Logic needed for missing value

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.

2.PNG

Required output:

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

1.PNG

Please help me.

Thanks in advance.

1 Solution

Accepted Solutions
Qrishna
Master
Master

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:

1.PNG

View solution in original post

2 Replies
shiveshsingh
Master
Master

for your specific date, you can put calculated dimension.

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

Qrishna
Master
Master

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:

1.PNG