Set analysis with conditions

[VamsiBhagavathula1]

Hello Guys,

Could someone please tell me how to do a field comparison inside set analysis based on the Qlik calendar?

in my case, one customer has multiple refunds for a order on different dates. Qlik calendar is giving me multiple rows for the refund dates(like cross join) . Out of this i need only the rows where calendar date matches refund date.  After this , I need to make some set analysis.

So, mainly, I want to achieve this Date comparison of calendar date & refund date in set analysis and perform count & sum aggregations.

Please see the screenshot attached. Please tell me how can i achieve it set analysis.

QVF File attached

Thanks,

Vamsi

[edwin]

try sum(if(date=refundDate,1,0))

having said that where does Date from the picture come from?  is it selected by the user?

[VamsiBhagavathula1]

@edwin : Date come from Qlik Torbien calendar. i will try it and let you know

[Sabrina_V]

Maybe in the set analysis date={"if(date=refundDate,1,0)=1"}

But, I wonder if the AGGR function would not be necessary