Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Samanehsorournejad

How to Store file with If Condition

Hi Every One,

I wanted to Store my CSV File after checking the If condition.

at first I try to find the Date and count(id) as countid1 for 2 Months ago and then I try to find the Data for last Mount and its Count(id) as countid2.

like this:

test2:
load
count(id) as countid1,
// Peek(count(id)) as countid2,
month(datum) & '_'& year(datum) as Month_years
Resident  Datei
where month(datum)<= Month(AddMonths(Today(),-2))
and month(datum) > Month(AddMonths(Today(),-3))
and Year(datum) =Year(AddMonths(Today(),-1))
group by month(datum) ,year(datum);

test3:
load
count(id) as countid2,
month(datum)&'_'& year(datum) as Month_years
Resident Datei
where month(datum)<= Month(AddMonths(Today(),-1))
and month(datum) > Month(AddMonths(Today(),-2))
and Year(datum) =Year(AddMonths(Today(),-1))
group by month(datum) , year(datum);

now I want to save my CSV data but at first I should check if the difference between 2Months ago and one Month ago less than or equal 2 is and if yes then Store my Data

I had try this:

set vResualt2=countid1-countid2;

if $(vResualt2) <=2 then
STORE [Datei] INTO ....... (delimiter is ';');
end If

 without if Condition it works but I need at first Check and then Store it.

 

Is there anyone who could Help me PLease

 

3 Replies
tm_burgers
Creator III
Creator III

set vResualt2=countid1-countid2;

 

you need to peek the values of countid1 and countid2 and store each of those peeks as their own variable (my preference)

 

let vCountId1 = peek('countid1',0,'test2')

let vCountId2 = peek('countid2',0,'test3')

 

set vResualt2 = $(vCountId1) - $(vCountId2)

 

then :

if $(vResualt2) <=2 then
STORE [Datei] INTO ....... (delimiter is ';');
end If

 

Digvijay_Singh

May be you need to use 'Peek' while you are referencing data table fields countid1 and id2.

LET countid1 = peek('countid1');
LET countid2= dpeek('countid2');

set vResualt2=countid1-countid2;

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

 

Samanehsorournejad
Author

Thanks  a lot 🙂