Converting If condition to Set Analysis

[sangeeth8787]

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.

[Sue_Macaluso]

@sangeeth8787 Are you using QlikView or Sense?  I would like to move this into the correct product forum. Thank you.

[sangeeth8787]

I am using QlikView

[Brett_Bleess]

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

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

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