Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
harsha
Creator
Creator

Save data to Excel from load Script

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.

CompanyIDProductIDYearValueCategory
123C342019100Stable
123C322020130Increase
452C34201890Decrease
452C322019120Stable
879C342019110Stable
879C322020155Extreme

 

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

Labels (2)
1 Solution

Accepted Solutions
Taoufiq_Zarra
Master II
Master II

@harsha  if I understood correctly

where match (Category,'Not in From System','Stable','Increase','Decrease')>0;

....
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra
Master II
Master II

@harsha  if I understood correctly

where match (Category,'Not in From System','Stable','Increase','Decrease')>0;

....
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

harsha
Creator
Creator
Author

yes.. this works @Taoufiq_Zarra  Thank u 🙂