how can we make this chart

[#1]

how can we make this chart if i select Aug-2010

then we want to see figure last year previous three month just like ( june-2009,july-2009,Aug-2009).

How can we make this logic help me urgent basic .

Regards

Ashish Srivastava

[#2]

Dear All

kindly requested to you please help me in this issue.

It's a very urgent,

Regards

Ashish Srivastava

[#3]

no comprenday

[#4]

Yes compredday

Example if i select 11-Aug-2010

Then we want to see data for 1-june2009 to 11-Aug-2009 month wise.

Regards

Ashish Srivastava

[#5]

Help me.

Regards

Ashish Srivastava

[#6]

i dunno

[#7]

Dear Ashish,

PFA of Rolling.qvw may be it is helpfull for you

[#8]

Dear Santhosh,

Thank for helping me but we want previous three month data.

What ever you select month.

Regards

Ashish Srivastava

[#9]

Hi,

If you are using QV 8.5 or later version, your code should be smilar to following code.

//untested code

sum({<Selection_Field = {">=$(=Monthstart(addmonths(Selection_Field,-3)))}<=Max(Selection_Field)"})

-Sridhar

[#10]

Hi Sridhar,

I have test this code but it's not working.

Kindly requested to you if you have any qvw example file please send me this is more use full for me.

Currently i have used qlikview 8.5 version.

Regards

Ashish Srivastava