date issue

[qlikapple]

HI all,

i have  qvd which holds 2 months data,

we have taken the qvd as such if the qvd runs on Nov1st it holds Oct and NOv data

and if the qvd runs  from Dec 1st  the qvd holds the  Nov and Dec 1st data.

Now my requirement is

in the qvd i need to apply the filter as if the qvd runs  from Nov 1st to NOV 4th the qvd has to show OCT data only.

and if the qvd runs from Nov 4th , the qvd has to show from Nov 1st data.

How to proceed

can anyone helpplease

[qlikapple]

Hi anyone please help

[tharanikannan]

Hi

Please add your filters in where clause

Ex : For OCT data

where START_DATETIME>=1st nov and END_DATETIME<=4thnov

[qlikapple]

please find the attached qvw

[tharanikannan]

Hi ,

Please attach your qvw. I am not able to see anything.

Thanks.

[qlikapple]

anyone please look into it issue

[qlikviewwizard]

Can you attach some dummy data?

[qlikapple]

please find the dummy data

[qlikapple]

HI all,

i have  qvd which holds 2 months data,

we have taken the qvd as such if the qvd runs on Nov1st it holds Oct and NOv data

and if the qvd runs  from Dec 1st  the qvd holds the  Nov and Dec 1st data.

Now my requirement is

in the qvd i need to apply the filter as if the qvd runs  from Nov 1st to NOV 4th the qvd has to show OCT data only.

and if the qvd runs from Nov 4th , the qvd has to show from Nov 1st data.

anyhelpplease