Discussion Board for collaboration related to Creating Analytics for QlikView.
I'm making a straight table with a sum of purchases shown for each month. This first column is for cloths, the next for household goods etc...
making the sum is not difficult: Sum(amount) but when I add an 'if' so I only include items that are cloths (for example Goods='cloths') the result is always zero.
Whats wrong with this statement as expression:
What should be changed?
Go to Solution.
Thanks a lot!
Just a small point - avoid using 'if' wherever possible as it has a perfomance overhead particularily with large amounts of data.
This should be more efficient: