topic Re: If..else condition not working in QlikView

If..else condition not working

gfisch13 — Sat, 16 Nov 2024 02:04:04 GMT

Hi all - I've tried to use the following IF/Else expression but I'm getting an error. What am I doing wrong?

if([CC_MCC_Desc] = 'Grocery_Stores_and_Supermarkets'), Sum([CC_Item_Cost]), Sum([CC_Tran_Amt])

If the condtion is true I'm taking a Sum of a field, if the condution is false I'm taking a Sum of a different field.

Appreciate any comments. Thanks!

sunny_talwar — Thu, 31 Oct 2019 16:31:29 GMT

You have an extra parenthesis and a missing one at the end

if([CC_MCC_Desc] = 'Grocery_Stores_and_Supermarkets'), Sum([CC_Item_Cost]), Sum([CC_Tran_Amt]))

Try this

If([CC_MCC_Desc] = 'Grocery_Stores_and_Supermarkets', Sum([CC_Item_Cost]), Sum([CC_Tran_Amt]) )

gfisch13 — Thu, 31 Oct 2019 17:01:50 GMT

Thanks Sunny T!