topic how to create a variable script in QlikView

how to create a variable script

dmxmikey — Wed, 25 Nov 2020 16:16:04 GMT

I have below script and would like to output word Gluten, if its either C or P or M

M2_Allergens:

left join (Allergy_tmp)

Load

[p-code],

/

if(Gluten='C' or 'P' or 'M','Gluten') as M2_Allergens

Resident Allergy_tmp;

Re: how to create a variable script

Anil_Babu_Samineni — Tue, 04 Jul 2017 17:25:16 GMT

Title looks like you need variable,

M2_Allergens:

left join (Allergy_tmp)

Load

[p-code],

/

if(Match(Gluten,'C' , 'P' , 'M'),'Gluten', Gluten) as M2_Allergens

Resident Allergy_tmp;