topic FromDate and Todates fields are not Working in QlikView

FromDate and Todates fields are not Working

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

Hi,

Attached the Sample qvw. I created from date and todate in Calendar object to select the dates. But when i select from and todate data in table box is not responding to the date selections. I will be able to select from and todate and data should show based on the date selections. Please have a look at my sample qvw and reply me as soon as possible.

Thanks in advance!

Re: FromDate and Todates fields are not Working

sweety0912 — Thu, 08 Aug 2019 15:11:48 GMT

Can anyone respond Please??

Re: FromDate and Todates fields are not Working

m_woolf — Thu, 08 Aug 2019 15:14:07 GMT

https://www.youtube.com/watch?v=UTDyO68BYL8&t=260s

Re: FromDate and Todates fields are not Working

sweety0912 — Thu, 08 Aug 2019 15:24:54 GMT

I tried all this and it is not working in my scenario some how. I also attached my sample qvw. Could you please have a look and let me know what i am missing it.

Re: FromDate and Todates fields are not Working

m_woolf — Thu, 08 Aug 2019 15:28:22 GMT

You don't have triggers on your vStartDate and vEndDate variables.

Re: FromDate and Todates fields are not Working

sweety0912 — Thu, 08 Aug 2019 15:32:05 GMT

Can you please reply me with the qvw? I am not able to achieve it some how. I really appreciate your help!

Re: FromDate and Todates fields are not Working

Frank_Hartmann — Thu, 08 Aug 2019 15:53:30 GMT

see attached qvw

hope this helps

Re: FromDate and Todates fields are not Working

sweety0912 — Thu, 08 Aug 2019 15:59:16 GMT

I have tried same thing that what you did in workflow but still if i select from and to date data is not showing based on selections.

Re: FromDate and Todates fields are not Working

sweety0912 — Thu, 08 Aug 2019 16:48:59 GMT

I have used this formula Load *, Date#(SubField(Date1,' ',1),'M/D/YYYY') as Date;

After using the formula date is showing in number format so unable to select the From and todates. Attached the screenshot too. Can you please have alook?

Re: FromDate and Todates fields are not Working

m_woolf — Thu, 08 Aug 2019 17:09:38 GMT

Try replacing Date# with Date.

Re: FromDate and Todates fields are not Working

sweety0912 — Thu, 08 Aug 2019 17:17:19 GMT

I did everything and i am able to select the from and to dates now. But data is not responding for the date selections i made it. Is there anything i need to do?

Re: FromDate and Todates fields are not Working

sweety0912 — Thu, 08 Aug 2019 18:01:37 GMT

Thank you for all your help! It is working as expected!