Aggr with range the date

[jsobrinho]

Hi guys,

I have a expression that calculate the YTD value from some dimensions, and I need to create a rank from this values.

So my expression is like that:

aggr(Rank(Total(

sum({<$(vDimensions),Year=, Month=, Calendar={"<=$(=Max(Calendar))"}, Year={$(=Max(Year))},MetricsA={'>0'}>}Value),4,1),$(vDimensions))

But I think that I need something like that:

sum({<$(vDimensions),Year=, Month=, Calendar={"<=$(=Max(Calendar))"}, Year={$(=Max(Year))},MetricsA={'>0'}>}Value),4,1),$(vDimensions),$(vYTD))

Where vYTD is Calendar={"<=$(=Max(Calendar))"}, Year={$(=Max(Year))

But I don't know how to create the logical here in the aggr area.

@sunny_talwar  any idea?

[sunny_talwar]

Would you be able to share a sample where I can see this expression getting used? Also, what is the output you expect to see based on the data shared?

[Brett_Bleess]

Jose, the following Design Blog might help:

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

If that is not what you need, search from the following link yourself to see if you can find a post that helps if you cannot attach app etc. for Sunny.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett