Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor

Sum totals for various products


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?

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?

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.
Valued Contributor II

Re: Sum totals for various products

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