Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
***New to Qlik sense***
Data model:
TABLE_1:
Product_ID | Product_name | Cost |
xy_123 | table | 14 |
sub_481 | chair | 27 |
xy_102 | fan | 18 |
TABLE_2:
Sub_product_id | Sub_product_name | Cost |
sub_481 | chair | 27 |
I need to make a chart for Table 1 but exclude records which are present in Table 2. I.e. how can I exclude the sub_481 record from the chart? Also, I need to exclude the records at the chart/sheet level, not at the script.
@andewan do you want to remove the records at the script level?
TABLE_2:
LOAD * INLINE [
Sub_product_id , Sub_product_name , Cost
sub_481 , chair , 27
];
TABLE_1:
LOAD * INLINE [
Product_ID , Product_name , Cost
xy_123 , table , 14
sub_481 , chair , 27
xy_102 , fan , 18
]WHERE NOT Exists(Sub_product_id, Product_ID);
drop table TABLE_2;
output:
@Taoufiq_Zarra Thank you for your response 🙂
I have edited my question - I need to remove the records not at the script but at the chart/sheet level.