topic Re: From Date and To Date in QlikView

From Date and To Date

Inna_Shnaiderman — Tue, 02 Mar 2021 15:22:43 GMT

I have on all Reports Calendar Date Range. I created it according to other posts. Unfortunately, on 'Date from' it is working and 'Date to' is not impacting . A did all according to this post:

https://community.qlik.com/t5/QlikView-App-Dev/how-to-show-the-value-quot-from-date-quot-to-quot-to-date-quot/td-p/847389

But it is taking all dates 'from' and not not taking into consideraion' to'.

Re: From Date and To Date

Martijn_W — Tue, 02 Mar 2021 17:05:45 GMT

Hi,

I've reproduced the steps. I got it working in the attached example file. Feel free to compare the code. I did notice that you copied the entire format portion of the code in the explanation, while your date field is just a date format ( DD/MM/YYYY hh:mm:ss instead of just DD/MM/YYYY).

Hope this helps!

Martijn

Re: From Date and To Date

Inna_Shnaiderman — Wed, 03 Mar 2021 09:29:13 GMT

Hi,

I tried this , it is not helping, for some reason Date_to is being showed in my model in selection as MM/DD/YYYY hh:mm:ss and the final selection is impacted only from Date_From. PSA. Can you please help how to get rid of this date format issue.

Re: From Date and To Date

Martijn_W — Wed, 03 Mar 2021 09:29:07 GMT

Hi,

I recommend truncating the time portion if it's not needed. You can use:

dayname(floor(<datefield>)) as <datefield>

in your loadscript to accomplish this.

floor() will round the datefield down to a whole number, dayname() will convert the number back to a date.

Re: From Date and To Date

Inna_Shnaiderman — Wed, 03 Mar 2021 12:42:32 GMT

Hi,

I tried it , still it did not solve the issue, it is the same result.

Re: From Date and To Date

Martijn_W — Wed, 03 Mar 2021 12:46:00 GMT

Can you share the code of the following items?:

- the calendar objects of both of the date ranges

- the code of the button (the search string input)

Also, does it work if you clear all the selections first?

Re: From Date and To Date

Inna_Shnaiderman — Wed, 03 Mar 2021 13:04:17 GMT

Hi,

Date From:

Min Value:

min({1} DD_Solution_Leg_PTD)

Max Value:

max({1} DD_Solution_Leg_PTD)

Variable: VPTDFROM

Date To:

Min Value:

min({1} DD_Solution_Leg_PTD)

Max Value:

max({1} DD_Solution_Leg_PTD)

Variable PTDTo

Apply Button:

='>=' & Date( VPTDFrom , 'MM/DD/YYYY') & '<=' & Date(VPTDTo, 'MM/DD/YYYY')

'Clear All' does not help in the beginning.

Thanks!