topic Sum formula in QlikView

Sum formula

danialier — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm new on QlikView

I'd like to do a sum formula but I don't know how to do it.

I want to do the sum of Revenues for product A and I use the following formula but it does not work

sum({Product=A}Revenues)

Please help !

Thanks,

dani

kaushiknsolanki — Tue, 21 Feb 2017 10:15:54 GMT

You just missed.

See below

sum({<Product={"A"}>}Revenues)

Regards,

Kaushik Solanki

sasikanth — Tue, 21 Feb 2017 10:16:22 GMT

HI,

Try this

=Sum({<Product= {'A'} >}Revenues)

danialier — Tue, 21 Feb 2017 10:16:54 GMT

Many Thanks Kaushik !

It works now