I'm working in Qliksense and generated some flags based on some conditions.
I want to store the data in a local folder.
I'm able to store entire table STORE Sample INTO lib://Test/Check_1_Test_Export.csv (txt);
however I have a column like below which has "WithDecimal" or "WithoutDecimal" and I want to store/save into CVS or XLSX where Check_1_Flag is 'WithoutDecimal'?
how to save only WithoutDecimal in CSV?
Hi @harsha I believe that you have two problems.
First your flag, doesn't work well, when I was checking your table, you have flag for data that not is decimal number.
Try something like this: if( isnull(even(Value), 'WithoutDecimal','Decimal') as _falg
And aditional, when you store use the code that @Kush give you to store, that can will solve your dude.
I quote you @Kush:
STORE Sample INTO lib://Test/Check_1_Test_Export.csv (txt);
If you need store twice, use a for for your field, something like this:
for each _flag in fieldvaluelist(_flag)
Load * resident sample where _flag = '$(_flag)';
STORE dataTmp INTO lib://Test/Check_1_Test_Export_($_flag).csv (txt);
drop t able dataTmp;
Thanks for the quick response... but my expectation is something diff.
I want to save only when one particular dimension meets a validation.
Ex: store when Year = 2019
something like above
I have the below output saved but I want to save only 'withdecimal' results from 'Check_1_Flag' (column/dimension)
This (STORE Check2 INTO lib://Test/Check_1_Flag.csv (txt);) saves both 'WithDecimal' and 'WithoutDecimal' but how can I save only the 'WithDecimal'?