topic Re: Aggr with range the date in QlikView

Aggr with range the date

jsobrinho — Sat, 16 Nov 2024 02:25:43 GMT

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?

Re: Aggr with range the date

sunny_talwar — Mon, 30 Sep 2019 12:56:25 GMT

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?

Re: Aggr with range the date

Brett_Bleess — Tue, 01 Oct 2019 16:05:40 GMT

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