Qlik Sense Where Condition in script: need to use two where conditions those two conditions should execute based on the if condition

Anonymousman — Tue, 30 Nov 2021 18:17:33 GMT

Hi,

I have fields like skey_date, month_offset,day_in_month_nr, if day_in_month_nr is 1 then I should get min(skey_date) only for month_offset=-1 or else then I should get min(skey_date) only for month_offset=0.

I tried using following in script it is not working:

if (day_in_month_nr)=1 then
LOAD min(skey_date) as date
FROM $(vQVDLib)date_dim.qvd (qvd)
where month_offset=-1;

else

LOAD min(skey_date) as date
from FROM $(vQVDLib)date_dim.qvd (qvd)
where month_offset=0;
end if

appreciatr all your help. Kindly provide me solution for this.

Awaiting your responses

topic Qlik Sense Where Condition in script: need to use two where conditions those two conditions should execute based on the if condition in App Development

Qlik Sense Where Condition in script: need to use two where conditions those two conditions should execute based on the if condition