topic Re: Two conditions to count the sum in QlikView

Two conditions to count the sum

Tue, 16 May 2017 07:32:58 GMT

Hi guys,

I have the following table:

I apply the condition: SUM({<[Month]={'1'}>} [Amount]) and get this:

For the second table I need to count the sum of amount with only indexes A, B, and C, but the statement

=sum( {<[Index]={'A','B','C'}>} {<[Month]={'1'}>} [Amount]) doesn't work.

As a result I need to get in the text object the sum = 68

Does anybody have some ideas how to apply to conditions to get the right answer?

Thanks a lot for anysuggestions in a advance!

Anonymous — Tue, 16 May 2017 07:35:44 GMT

Hi Alexander,

try this:

sum( {$<[Index]={'A','B','C'},[Month]={1}>} [Amount])

Hope this helps

Tue, 16 May 2017 07:41:07 GMT

Yes, it works! 😃 Thanks a lot !

Anonymous — Tue, 16 May 2017 07:44:27 GMT

No problem, happy to help!