Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I have loaded my data from QVD and made some changes to create some flags based on some criteria. I want to save data into Excel from load script but not the entire data but based on one dimension Categories
Ex: here I want to save where Category= Stable, Increase ,Decrease but not Extreme.
CompanyID | ProductID | Year | Value | Category |
123 | C34 | 2019 | 100 | Stable |
123 | C32 | 2020 | 130 | Increase |
452 | C34 | 2018 | 90 | Decrease |
452 | C32 | 2019 | 120 | Stable |
879 | C34 | 2019 | 110 | Stable |
879 | C32 | 2020 | 155 | Extreme |
I am using below script to save only one Category but how to give multiple Categories ?
where match (Category,'Not in From System');
store Excel_Test into [lib://QVD_Transform/Qlik_Data_Test.csv] (TXT) ;
@harsha if I understood correctly
where match (Category,'Not in From System','Stable','Increase','Decrease')>0;
....
@harsha if I understood correctly
where match (Category,'Not in From System','Stable','Increase','Decrease')>0;
....
yes.. this works @Taoufiq_Zarra Thank u 🙂