Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
robbiewottie
New Contributor III

Set Anlaysis issue

Hi Guys,

I Have an issue with a rangeavg calculation. I use a moving average with the rangeavg function:

sum(aggr( rangeavg(above( $(vProjectPipelineM2)/$(vProjectPipeline#),0,3) ),Ring,YearMonth))

This works fine. But now I want to exclude YearMonth (as with YearMonth=)  from the selections as this will recalculate from selecting fields. That's unwanted. Were do I put thise exclusion in the set analysis?

Pls advice

Robert

Tags (1)
3 Replies

Re: Set Anlaysis issue

You probably would need to do that within your variables

vProjectPipelineM2

and

vProjectPipeline#

and here

Sum({<YearMonth>} Aggr(.....

miguelbraga
Valued Contributor III

Re: Set Anlaysis issue

Try simply this:

sum({$<YearMonth= >} aggr( rangeavg(above( $(vProjectPipelineM2)/$(vProjectPipeline#),0,3) ),Ring,YearMonth))

Best regards,

D.A. MB

filip_duchateau
Contributor II

Re: Set Anlaysis issue

Try to put {$<YearMonth= >} in front of the aggr function.  That should work.