Need to create a rolling 4 months based on Variabel

[uko223]

Hi, I need to create a chart that shows a rolling 4 months. However, I am having an issue which I believe is syntax related.

I created a variable which always shows the current fiscal quarter ID, which is currently 71(variable is vCurrentFiscalQuarterId). I want to use set analysis to show the current shipment amounts for each quarter prior to the current one going back one at a time. However, I am having an issue with the set analysis below as it returns null results.

Sum({$<

[Fiscal - Quarter Id]={'=(($(vCurrentFiscalQuarterId)-1)'}

>}[Amount - Shipped/Fulfilled USD])

Any help would be great.

Thanks!

[tajmohamed30]

QlikView Tutorials | QlikView Scripting | Peek and Previous Function in QlikView - YouTube