topic Re: Set Anlaysis issue in QlikView

Set Anlaysis issue

Anonymous — Tue, 27 Sep 2016 09:33:58 GMT

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

Re: Set Anlaysis issue

sunny_talwar — Tue, 27 Sep 2016 09:36:27 GMT

You probably would need to do that within your variables

vProjectPipelineM2

and

vProjectPipeline#

and here

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

Re: Set Anlaysis issue

miguelbraga — Tue, 27 Sep 2016 09:37:37 GMT

Try simply this:

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

Best regards,

D.A. MB

Re: Set Anlaysis issue

Anonymous — Tue, 27 Sep 2016 09:46:56 GMT

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