topic Re: date issue in QlikView

date issue

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 01 Nov 2018 04:56:38 GMT

Hi anyone please help

tharanikannan — Thu, 01 Nov 2018 05:11:52 GMT

Please add your filters in where clause

Ex : For OCT data

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

qlikapple — Thu, 01 Nov 2018 05:36:58 GMT

please find the attached qvw

tharanikannan — Thu, 01 Nov 2018 05:42:43 GMT

Hi ,

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

Thanks.

qlikapple — Thu, 01 Nov 2018 06:16:04 GMT

anyone please look into it issue

qlikviewwizard — Thu, 01 Nov 2018 06:30:09 GMT

Can you attach some dummy data?

qlikapple — Thu, 01 Nov 2018 06:51:49 GMT

please find the dummy data

qlikapple — Thu, 01 Nov 2018 08:52:24 GMT