Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco
New Contributor III

Need to create a rolling 4 months based on Variabel

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!

1 Reply
tajmohamed30
Contributor III

Re: Need to create a rolling 4 months based on Variabel