topic Re: Sum(Total ) with condition in QlikView

Sum(Total ) with condition

sohb2015 — Wed, 04 Nov 2015 11:18:58 GMT

Hello All,

I am trying to create an expression:

sum(total{<product={A}>}sales) and it's working.

But I want to put another dimension in the table i.e. country. For example, I want to display my sales data for each country for product A.

So, the expression will be like below:

sum(total{<country,product={A}>}sales) but this does not work.

Can you anyone help me with this.

Thanks

sunny_talwar — Wed, 04 Nov 2015 11:58:10 GMT

May be this:

Sum(TOTAL <country> {<product = {'A'}>} sales)

MayilVahanan — Wed, 04 Nov 2015 11:59:12 GMT

You can simply use like this

Dim: Country, Product
Exp: sum({<country=,product={A}>}sales) or sum(total{<product={A}>}sales)