Condition in set analysis.

[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 file of QVF & screenshot. Please let  me know  how  we can achieve it set analysis.

Thanks,

Vamsi

[VamsiBhagavathula1]

@vinieme12  yes it does but now my facts ORDERS & REFUNDS were joined by synthetic key . i am loosing my original join which C_ID on the fact tables.

is it better to have synthetic keys in general ??

[vinieme12]

just drop field C_ID from REFUNDS and Orders table;

DROP FIELD C_ID ;

[VamsiBhagavathula1]

Hi @vinieme12 ,

Though compound key worked for Dates stuff, When i pull in dimensions into the table, The data gets broken.

I am attaching the qvf file, Can you please let me know if we could get actual data related with dimensions liked ??