Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two conditions to count the sum

Hi guys,

I have the following table:

1.PNG

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

2.PNG

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!

1 Solution

Accepted Solutions
mattquinnterex
Creator II
Creator II

Hi Alexander,

try this:

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


​Hope this helps

View solution in original post

3 Replies
mattquinnterex
Creator II
Creator II

Hi Alexander,

try this:

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


​Hope this helps

Not applicable
Author

Yes, it works! 😃 Thanks a lot !

mattquinnterex
Creator II
Creator II

No problem, happy to help!