Nested IF statement as a variable in the Script

Fri, 22 Jul 2016 09:29:52 GMT

Question: How are the below variables written in the script? The Qlik Sense application sits on the SERVER, hence the requirement for SCRIPT VARIABLES.

vUserProductGroup

concat(Distinct Site_Master_Person_Product_Group)

vProductDivision

=if($(vUserProductGroup) = 'MOBILE','IM', if($(vUserProductGroup) = 'TV','TVAV'))

This is the KPI expression:

*************************************************************************************************

if(vProductDivision = 'IM',

(sum({<[Product PREMIUM] = {'Premium'},[Product RM Division] = {$(vProductDivision)}>}Sell_Out_Qty)

sum({<[Product RM Division] = {$(vProductDivision)}>}Sell_Out_Qty)),

if(vProductDivision = 'TVAV',

(sum({<[Product PREMIUM] = {'PREMIUM'},[Product RM Division] = {$(vProductDivision)}>}Sell_Out_Qty)

sum({<[Product RM Division] = {$(vProductDivision)}>}Sell_Out_Qty))))

*************************************************************************************************

Re: Nested IF statement as a variable in the Script

sunny_talwar — Fri, 22 Jul 2016 11:23:41 GMT

May be look at Stefan's response here:

Re: Expression as a variable with $-sign expansion

topic Nested IF statement as a variable in the Script in App Development

Nested IF statement as a variable in the Script

Re: Nested IF statement as a variable in the Script