topic Re: Creating the calendar and input box in QlikView

Creating the calendar and input box

memela — Mon, 14 Mar 2022 08:40:24 GMT

Hi Guys

I have created the calendar and the input box as below. the variable vStartdate and vEndDate have been created and the date formats matches the date field date format. But it seems not to be functioning correctly as you can see bellow and whenever I make a selection on dates, it doesn't give correct range on my data table. Any advice?

Re: Creating the calendar and input box

anat — Mon, 14 Mar 2022 11:57:53 GMT

what logic you are passing to filter dates?

Re: Creating the calendar and input box

Colin-Albert — Tue, 15 Mar 2022 19:13:21 GMT

Can you explain exactly what the problem is?
Your filter has a start date 4/Jan/99 and an end date 20/Jan/99 and the values in the Timestamp_1 listbox match this range.
Are your dates held as integer date values?
Is the timestamp_1 data an integer date or a floating point timestamp?

These posts by Henric may help clarify how to correctly format date fields
https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

Get the Dates Right

Why don’t my dates work?

Re: Creating the calendar and input box

memela — Tue, 22 Mar 2022 07:58:54 GMT

Hi,

Whenever I select a date range from the calendar, it does not filter the correct date range from field TimeStamp_1 r List box.