Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sahajaqlik
Contributor

date issue

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

8 Replies
sahajaqlik
Contributor

Re: date issue

Hi anyone please help

tharanikannan
New Contributor III

Re: date issue

Hi

Please add your filters in where clause

Ex : For OCT data

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

Highlighted
sahajaqlik
Contributor

Re: date issue

please find the attached qvw

tharanikannan
New Contributor III

Re: date issue

Hi ,

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

Thanks.

sahajaqlik
Contributor

Re: date issue

anyone please look into it issue

Arjunarao
Honored Contributor II

Re: date issue

Can you attach some dummy data?

sahajaqlik
Contributor

Re: date issue

please find the dummy data

sahajaqlik
Contributor

Re: date issue

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

Community Browser