12 month roll

[#1]

Hi,

Can anyone help me create an expression for measuring 12 rolling sales.

Thomas

[#2]

Yes:-)

[Bjorn_Wedbratt]

Hi Thomas,

Not sure if you need this to be done using Set Analysis. Personally I prefer to generate aggregations like this in the script (but may be because I'm used to "the old way", before Set Analysis was even included in QlikView )

If you can live with generating it in the script, I attached a small example that I think you can tweak to your liking.

Best,

Bjorn