Hi Community,
I need to build a logic at front end using Set Analysis which will pick all those product Names which are missing in between the dates.
Let me explain the requirement. Here is the table:
| Work_date |
Prod_Name |
Value |
Date_Num |
Date_Num_Product |
| 30/1/2022 |
Mobile |
40000 |
44591 |
44591-Mobile |
| 30/1/2022 |
Charger |
1000 |
44591 |
44591-Charger |
| 30/1/2022 |
Cable |
4000 |
44591 |
44591-Cable |
| 31/1/2022 |
Mobile |
50000 |
44592 |
44592-Mobile |
| 31/1/2022 |
Charger |
2000 |
44592 |
44592-Charger |
| 31/1/2022 |
Cable |
3000 |
44592 |
44592-Cable |
| 4/2/2022 |
Mobile |
10000 |
44596 |
44596-Mobile |
| 4/2/2022 |
Cable |
1000 |
44596 |
44596-Cable |
| 15/2/2022 |
Mobile |
50000 |
44607 |
44607-Mobile |
| 15/2/2022 |
Cable |
5000 |
44607 |
44607-Cable |
| 7/3/2022 |
Mobile |
60000 |
44627 |
44627-Mobile |
| 7/3/2022 |
Charger |
3000 |
44627 |
44627-Charger |
| 7/3/2022 |
Cable |
4000 |
44627 |
44627-Cable |
| 7/3/2022 |
Insurance |
6000 |
44627 |
44627-Insurance |
30/01/2022 - It has 3 Products: Mobile, Charger & Cable
31/01/2022 - It has 3 Products: Mobile, Charger & Cable
04/02/2022 - It has 2 Products: Mobile & Cable
15/02/2022 - It has 2 Products: Mobile & Cable
07/03/2022 - It has 4 Products: Mobile, Charger, Cable & Insurance
If you see 30/01/2022 & 31/01/2022 has 3 products and 07/03/2022 all those 3 products available in it but if you see
04/02/2022 and 15/02/2022, they have only 2 products. So, in this one product is missing which is 'Charger'.
So, I want to highlight 'Charger' as missing product.
'Insurance' is not a missing product because it is not available in 30/01/2022 & 31/01/2022.
What I'm thinking & trying:
When a user selects some random date range then using Set analysis, the code will pick max & min date and compare all the products in-between those range with the min & max date products.
Is this scenario possible in Qlik Sense??
Regards,
Eric
