Rolling Months on charts for finding Sales.

[#1]

Hey!! I am Beginner in using qlikview tool. I need some suggestion on rolling months concept used in charts to show output of sales.

Can anyone show me how to right expression  and what dimension should be used for showing sales using rolling month concept.

I have used unlink calendar concept.

I have created some variables

Dimension Used is as follows -

[Master Month]  field.

Expression I used is as follows -

=sum({<[Order Date]=,[Master Date]={">=$(vRolling)<= $(vtoday)"}>}NetSales)

On selection of master date its shows same values of NetSales on every selection. What Dimension should i used any suggestion?

Output without selection -

Output with selection -

Help me out.. Thanks

[kaushiknsolanki]

Hi,

Kindly share the sample data

Regards,

Kaushik Solanki