Last 6 quarters

[Sameer9585]

hi,

I required to get the barchart of previous 6 quarters from the selected quarter in qlik sense.

Below I provide the dataset of the related question

[jonathandienst]

You will get a better response if you load the data into a QlikSense app and at build the basic barchart. Then, if you  are not sure how to continue, you can ask a specific question and you will get a useful response.

[Vegar · Accepted solution]

If calculating Quantity over ShipDate try something like this. It calculates quantity between your largest selected ShipDate and 6 quarters back.

SUM( {$<ShipDate={">=$(=dayname(quarterstart(MAX(ShipDate), -6))) <=$(=MAX(ShipDate))"}>}Quantity)