Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

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
qlikapple
Creator
Creator
Author

Hi anyone please help

tharanikannan
Contributor III
Contributor III

Hi

Please add your filters in where clause

Ex : For OCT data

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

qlikapple
Creator
Creator
Author

please find the attached qvw

tharanikannan
Contributor III
Contributor III

Hi ,

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

Thanks.

qlikapple
Creator
Creator
Author

anyone please look into it issue

qlikviewwizard
Master II
Master II

Can you attach some dummy data?

qlikapple
Creator
Creator
Author

please find the dummy data

qlikapple
Creator
Creator
Author

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