Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
rpavan17
Contributor

Convert this sum aggr if expression to sum with set analysis aggr

Hi,

 

Can anyone help to convert this formula to set analysis expression?

Date_Clearing, Date_Posting and Month_End are in 'DD-MM-YYYY' format.

sum(aggr(if(sum(if(((IsNull(Date_Cl) AND Date_Pos <= Month_End ) OR (Date_Pos <= Month_End AND  Date_Cl > Month_End)) and SAP_TC='FBL1N' and trim(SP_GL)='' ,Amount_LOC,0))>0,

sum(if(((IsNull(Date_Cl) AND Date_Pos <= Month_End ) OR (Date_Pos <= Month_End AND  Date_Cl > Month_End)) and SAP_TC='FBL1N'and trim(SP_GL)='',

Amount_LOC,0)),0),VendorCC,Month_End))

 

Thanks

2 Replies
Highlighted
alex00321
Contributor

Re: Convert this sum aggr if expression to sum with set analysis aggr

Hi can you provide sample data maybe and also expected result? Thanks!

Highlighted
Digital Support
Digital Support

Re: Convert this sum aggr if expression to sum with set analysis aggr

Have a look at the following Design Blog post, believe it may be of some help on this issue:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.