Discussion Board for collaboration related to QlikView App Development.
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!
Hi Alexander,
try this:
sum( {$<[Index]={'A','B','C'},[Month]={1}>} [Amount])
Hope this helps
Hi Alexander,
try this:
sum( {$<[Index]={'A','B','C'},[Month]={1}>} [Amount])
Hope this helps
Yes, it works! 😃 Thanks a lot !
No problem, happy to help!