topic Re: Sum Totals with two different conditions in QlikView

Sum Totals with two different conditions

Anonymous — Thu, 19 Oct 2017 09:04:59 GMT

Hello all,

I'm trying to get a total in a denominator for reaching a 100% .

The thing is that I have two conditions parts in the expression so I need to have a total expression taking into account these conditions.

I have attached an example, the first expression is Okey, for the numerator but, for the denominator, I need to aggregate by totals and taking into account the condtions.

Any advice?

Thanks in advance

Re: Sum Totals with two different conditions

madhumitha — Thu, 19 Oct 2017 09:36:06 GMT

Hello Beatriz,

please try below expression as your denominator

Count(distinct{<TypeDate={'Atype'},State={'A'}>}idProduct) + Count(distinct{<TypeDate={'Btype'},State ={'B','C','D'}>}idProduct )

Thanks!

Re: Sum Totals with two different conditions

its_anandrjs — Thu, 19 Oct 2017 10:24:03 GMT

Find the attached for Denominator use this expression

Count(TOTAL distinct{<TypeDate={'Atype'},State={'A'}>}idProduct) + Count(TOTAL distinct{<TypeDate={'Btype'},State ={'B','C','D'}>}idProduct )

Re: Sum Totals with two different conditions

sunny_talwar — Thu, 19 Oct 2017 11:32:03 GMT

Here is another way to do this

Sum(TOTAL Aggr(If(State = 'A', Count(DISTINCT {<TypeDate={'Atype'}>}idProduct),

If(State = 'B' or State = 'C' or State = 'D', Count(DISTINCT {<TypeDate={'Btype'}>}idProduct))), State))

Re: Sum Totals with two different conditions

Anonymous — Fri, 20 Oct 2017 06:39:22 GMT

Thanks a lot Sunny, your solution worked and helped me as always.

Re: Sum Totals with two different conditions

Anonymous — Fri, 20 Oct 2017 06:39:46 GMT

Thanks a lot ! It works!

Re: Sum Totals with two different conditions

Anonymous — Fri, 20 Oct 2017 06:41:11 GMT

Thanks Madhu! I needed to add totals to that expression in order to work. Thanks for you help