Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Converting If condition to Set Analysis

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.

Labels (1)
3 Replies
Community Manager
Community Manager

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

Sue Macaluso
Highlighted
Contributor III
Contributor III

I am using QlikView

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.