Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Neha_2227
Contributor II
Contributor II

Show the status of customer that is not present in my main fact table

Hi Team,

Attached the sample data and scenario. 2 input tables - Table1 and Table2. Table1 is main fact table, Table2 is used as mapping table only (key- customerid&date)

Highlighted the example in yellow which is the current challenge, customer is not available in oct data but still need to show up as Y in Reconciled? column in frontend (because it has L1 status in table2)

Please let me know for an queries. Any suggestions would be really helpful.

Thank you so much in advance.

Regards

Neha

 

 

0 Replies