Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can any help me to convert following If condition to set analysis.
Sum(
if (Date<=(UserSelectedDate)
AND (DueDate > UserSelectedDate or Isnull(paydate))
,Amt,0)
)
The functionality of above code is doing running total with conditions. Instead of using If conditions, I would like to use Set analysis.
@sangeeth8787 Are you using QlikView or Sense? I would like to move this into the correct product forum. Thank you.
I am using QlikView
Rajesh, best I can do is provide a couple of links that may help you figure things out yourself:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Sorry I am not more help, this will bump the post back up to the top, so someone else may see things and be able to give you something else.
Regards,
Brett