topic Set analysis with conditions in App Development

Set analysis with conditions

VamsiBhagavathula1 — Tue, 25 Apr 2023 06:51:36 GMT

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

Re: Set analysis with conditions

edwin — Mon, 24 Apr 2023 20:40:17 GMT

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

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

Re: Set analysis with conditions

VamsiBhagavathula1 — Tue, 25 Apr 2023 05:29:53 GMT

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

Re: Set analysis with conditions

Sabrina_V — Tue, 25 Apr 2023 06:52:00 GMT

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

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