Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Set Analysis with field comparison

Hello Abraham,

my first idea wasn't so bad. And with it you pointed into the right direction. Look at your first post and try your expression with a good old if-statement:

sum(IF( ReceiptMon= SalesMon, ReceiptAmount, 0 ))

Hope this helps right now Smile


New Contributor

Re: Set Analysis with field comparison

hi Abraham,

this is an old question you have and i see that It has been unanswered since 2010. might be a closure to it if this works:

=sum( {$<SalesMon = {"=ReceiptMon"}>} ReceiptAmount)

best regards

Community Browser