topic Re: If Else Qliksense Load Script in App Development

If Else Qliksense Load Script

jasonrimkus — Sat, 16 Nov 2024 17:21:14 GMT

Migrating an App to Qliksense, the following script worked as intended in Qlikview, but is throwing syntax errors in QS.

the variable governs whether or not i want to load in where CustomerNLCStatusAsOfCall = 'N/L' or not. This greatly reduces the data, but sometimes i want to load them in for other analysis. \

if $(vLoadClients) = 0, Load this Script, Load other script

------------------------------------------------------------------------

if $(vLoadClients) = 0
Activities: NoConcatenate
Load * Resident ActivitiesTEMP
where year(ActivityDate) >= '$(vResultsThruYear)'
and (CustomerNLCStatusAsOfCall = 'N/L' or CustomerNLCStatusAsOfCall = 'UnMatched')
;
Else
Activities: NoConcatenate
Load * Resident ActivitiesTEMP
where year(ActivityDate) >= '$(vResultsThruYear)'
;
Endif;

Re: If Else Qliksense Load Script

GaryGiles — Thu, 25 Mar 2021 15:56:26 GMT

In Qlik Sense, you need a "then" with If and space between endif. Try this:

if $(vLoadClients) = 0 then
Activities: NoConcatenate
Load * Resident ActivitiesTEMP
where year(ActivityDate) >= '$(vResultsThruYear)'
and (CustomerNLCStatusAsOfCall = 'N/L' or CustomerNLCStatusAsOfCall = 'UnMatched')
;
Else
Activities: NoConcatenate
Load * Resident ActivitiesTEMP
where year(ActivityDate) >= '$(vResultsThruYear)'
;
End if

Re: If Else Qliksense Load Script

jasonrimkus — Tue, 06 Apr 2021 14:16:39 GMT

Thank you!