topic Re: Error in If Condition in App Development

Error in If Condition

seraphis — Tue, 21 Dec 2021 21:56:36 GMT

I see the red coloured part in the code below highlighted in red in Qliksense also and this code does not execute.

I am trying to create a new table taking all fields from another table Case1 and also create a new field called AssetFlag.

Case4:

Load *,
if Case_Flat_Case.Asset_Serial_Number <> Previous(Case_Flat_Case.Asset_Serial_Number) then
AssetFlag = "Yes";
end if
Resident Case1
order by Case_Flat_Case.Asset_Serial_Number,Case_Flat_Case.Date_Time_Opened asc;

Re: Error in If Condition

Gysbert_Wassenaar — Thu, 13 May 2021 11:54:26 GMT

Inside a load statement you have to use the If function not the If script statement

If(Case_Flat_Case.Asset_Serial_Number <> Previous(Case_Flat_Case.Asset_Serial_Number ), 'Yes', 'No') as AssetFlag

Note, the 'No' is optional. If you don't supply the third argument to the if function it will return Null if the condition in the first argument evaluates to false.

Re: Error in If Condition

seraphis — Thu, 13 May 2021 13:23:06 GMT

Thanks. It works!