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) ;
