Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kalpanaramjee
New Contributor

Sum totals for various products

Hi,

I have created a variable:

=if(Product = 'VAF', sum({1}[Vehicle and Asset Finance_2017]),
IF(Product = 'Overdraft', sum({1}Overdraft_2017),
IF(Product = 'CPF', sum({1}CPF_2017),
IF(Product = 'Debtors_Finance', sum({1}Debtors_Finance_2017),
IF(Product = 'Diners', sum({1}Diners_2017),
IF(Product = 'Lending', sum({1}Lending_2017),
IF(Product = 'Other_Debit', sum({1}Other_DB_2017),

IF(Product = 'Current_Account', sum({1}Current_Account_2017),
IF(Product = 'Investments', sum({1}Investments_2017),
IF(Product = 'Cashman', sum({1}Cashman_2017),
IF(Product = 'Call_Deposit_CIB', sum({1}Call_Deposit_CIB_2017),
IF(Product = 'Notice_Deposit_CIB', sum({1}Notice_Deposit_CIB_2017),
IF(Product = 'Other_Credit_Balances', sum({1}Other_Credit_Balances_2017)



)))))))))))))

However, the results are only displayed for the first one (VAF) .

5 Replies

Re: Sum totals for various products

Do you have Product as a dimension  in the object where you use this variable?

kalpanaramjee
New Contributor

Re: Sum totals for various products

Yes Product is a dimension

Re: Sum totals for various products

Then it should have worked, would you be able to share a sample where we can see the issue?

Highlighted
pradosh_thakur
Honored Contributor II

Re: Sum totals for various products

Where are you seeing the output of the variable?
In variable overview, Text box or any table?
If you are using it in text box it might not work as you are expecting it to work.
Learning never stops.
VishalWaghole
Valued Contributor II

Re: Sum totals for various products

Could you please try using Pick and match. Hope it will work.