topic Re: Datepicker in QlikView

Datepicker

Tue, 03 Sep 2013 13:21:17 GMT

Hello

Does anyone know if it is possible to make a datepicker in qlikview?

I thinking like this:

So Dato fra: is my from date, and Dato til: is my to date ?

Re: Datepicker

Gysbert_Wassenaar — Tue, 03 Sep 2013 13:25:25 GMT

Qlikview has a Slider/Calendar object. You can add two of those objects and choose Calendar as the Input Style. See this tutorial for an example: Selecting Arbitrary Date Ranges

Re: Datepicker

michael_maeuser — Tue, 03 Sep 2013 13:27:55 GMT

you mean object type "calendar object". just click on new object and create two of them. in the first one define a minvalue (min(date)) and variable (E.g. with your min date) and same with max(date) etc. for the "To-Date" object

Re: Datepicker

Tue, 03 Sep 2013 13:30:09 GMT

can i referer variables to this? - So if i input a date in the first i could make a variable called Datefrom and so on?

Re: Datepicker

Anonymous — Tue, 03 Sep 2013 15:57:27 GMT

Yes, it can be based on a field or on a variable - you choose. See tab "General", in the object properties. Create variablesDateFrom and DateTo, and use them in your calendar objects.

Regards,

Michael

Re: Datepicker

Tue, 03 Sep 2013 15:59:21 GMT

Thx, I know this is strange right. But when i give you a sample file, the variables work. But when i load all my data from QVD.qvw they doesnt work? Is that not strange?

Re: Datepicker

Anonymous — Tue, 03 Sep 2013 16:06:58 GMT

If variable exists, the calendar object works... Can you describe the "doesn't work"?

Re: Datepicker

Tue, 03 Sep 2013 16:10:55 GMT

Yes i can:

I have this secnario:

SourceLoad.qvw - Loads all my data from the source and store this into QVD files

QVDLOAD.qvw - Loads all the data from my qvd files

Design.qvw - Binary loads the data from QVDLOAD.qvw

In the first 2 documents, my variables work, and i can see when things change - But in my binary load, nothing happens even if i follow the video gysbert posted.

Is it because i have putten my variables in the first document (I set my variables in edit script)

Maybe i should only do it in design.qvw?

Re: Datepicker

Anonymous — Tue, 03 Sep 2013 16:14:22 GMT

Binary loads copies data (fields) but not the variables. You have to create the variables to make it work, I guess.

Re: Datepicker

Tue, 03 Sep 2013 17:09:24 GMT

Or maybe because i use Alternate state on sheet level?

But shouldnt my variable be able to pick on when is inherited?

Re: Datepicker

Anonymous — Tue, 03 Sep 2013 17:13:13 GMT

This is from "help":

Variables belong to the default state. Changes in other states will not affect

variable values.

Re: Datepicker

Tue, 03 Sep 2013 17:15:44 GMT

ohh ! brillant! thx man:)

Re: Datepicker

Tue, 03 Sep 2013 17:22:19 GMT

Sorry to write again, but i seem to have a problem when set variable trigger.

My variables are not affected by what i choose in my datefield.

Re: Re: Datepicker

Tue, 03 Sep 2013 17:28:37 GMT

I have attached a sample. I just canot get it to work - And when i want to type dates in variable - it makes it to numeric value?

Re: Re: Datepicker

Anonymous — Tue, 03 Sep 2013 17:32:29 GMT

This one is easy - go to Number tab and choose Date as format

Re: Re: Datepicker

Tue, 03 Sep 2013 17:35:35 GMT

but it is not working correctly- try to input two dates. then it takes all dates. And if u select af date from Dato it does not do anything in my variables

Re: Datepicker

Anonymous — Tue, 03 Sep 2013 18:45:33 GMT

Just tried the input box - worked fine. I typed 2012-01-05 as end date and 2012-01-01 as start date, and your actions selected Dato from 2012-01-01 to 2012-01-05. I recommend to put start date first and end date second in the input box, it is more natural.

Selection by Dato will change variables if you fix it a little

=date(Min(Dato))

=date(Max(Dato))

(Formatting is important when working with date/time)

Regards,

Michael

Re: Re: Datepicker

Wed, 04 Sep 2013 06:08:28 GMT

Ahh yes of cause.

I just thought when my datefield was formattet like a date, it could automatically see it. But no.

Thanks

Re: Datepicker

Anonymous — Wed, 04 Sep 2013 10:21:49 GMT

Dates and times are always converted to number format by min() and max() functions.