topic Re: Date picker stopped working in QlikView

Date picker stopped working

Thu, 17 Dec 2015 16:21:40 GMT

Ok so not a question of how to build something, and maybe not the right place for this but everyone here seems so knowledgable. I came across this issue yesterday and its really odd. I have a date range picker setup that populates using the min/max dates of REG_DATE field. While adding several variables in the app to pre-calculate things based on these variables, suddenly my date picker stopped working properly. The pull down for month is only showing the month and year from the most recent selection (Jan and 2015). vRegDateStart was previously selected as Jan 1 2015, vRegDateEnd was Jan 31 2015. There are valid dates in the table from 2014 to current, however those no longer show up, and the only thing I can do is select dates within the previous selection range, (i.e. Jan 2 to Jan 30), and once I do that I can no longer go back to the previous dates.

I save my apps in increments as I progress and this is happening to all previously saved revisions as well, without reloading the data.

I've tried restarting QV, saving a new versions and even updated QV to the latest. Any thoughts/suggestions?

Thanks in advance

Grant

Re: Date picker stopped working

Thu, 17 Dec 2015 17:56:57 GMT

can you post the app? it sounds like the variables somehow got tied into the generation or filter of the dates.

Re: Date picker stopped working

Thu, 17 Dec 2015 19:15:15 GMT

Im using personal edition, are you able to open those?

Re: Date picker stopped working

Thu, 17 Dec 2015 19:27:41 GMT

yes

Re: Date picker stopped working

Thu, 17 Dec 2015 19:41:24 GMT

Thanks for taking a look!

Re: Date picker stopped working

Thu, 17 Dec 2015 20:20:48 GMT

Apologies but I will not ahve a chance to look at it until tomorrow

Re: Date picker stopped working

Thu, 17 Dec 2015 20:22:00 GMT

np, thanks in advance for your help

Re: Date picker stopped working

Thu, 17 Dec 2015 20:44:16 GMT

her are the values for min and max reg_date

where are you setting vregstartdate and vregenddate

what values do you want the fields to have?

Re: Date picker stopped working

Thu, 17 Dec 2015 21:43:22 GMT

Try the following. I believe you need to override the default state in order to ensure the minimum from the entire set it retrieved in your Min/Max expressions. Without it, once you select a date the set is limited to what you have selected so the MinString will never go further back than that. You will need the {1} in both the min and max expressions.

=MinString({1} REG_DATE) .

Re: Date picker stopped working

Thu, 17 Dec 2015 21:56:07 GMT

I honestly can't say why, and perhaps it's something I did, without making any changes to the app its working again. very strange and I wish I had screenshots from before.

Adam I thank you very much for your help, this is a great community and I feel bad to have wasted your time.

Re: Date picker stopped working

Thu, 17 Dec 2015 22:02:13 GMT

That makes a lot of sense, it did seem to start working again but I will add that logic to be sure!

Re: Date picker stopped working

Thu, 17 Dec 2015 23:47:27 GMT

‌not a priblem

from my research it looks like something was not getting set because if I added a trigger to verify and set it worked

take care