Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
This is from "help":
Variables belong to the default state. Changes in other states will not affect
variable values.
ohh ! brillant! thx man:)
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.
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?
This one is easy - go to Number tab and choose Date as format
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
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
Ahh yes of cause.
I just thought when my datefield was formattet like a date, it could automatically see it. But no.
Thanks
Dates and times are always converted to number format by min() and max() functions.