topic Re: Default value on slider in QlikView

Default value on slider

rodri_morales — Tue, 01 Oct 2013 15:49:46 GMT

Hi everyone, well my problem is that I have a slider with this expresion: =year(BillDate) and I want that the slider start with a default value selected like "2013", it is posible?

I was looking for an option like "Default Value" (I saw them in sumple tables), but the slider doesnt have it.

Re: Default value on slider

israrkhan — Tue, 01 Oct 2013 16:18:34 GMT

hi,

try Year(Max(BillDate)), it will take max year ,if 2013 is max year in your DB,

if you have 2014 you can use Year(Max(BillDate)-1) and so...

Re: Default value on slider

rodri_morales — Wed, 02 Oct 2013 12:47:48 GMT

But I dont want to use only the max year, I want to show all year from bill, but start default value in 2013, do you understand?

Re: Default value on slider

israrkhan — Wed, 02 Oct 2013 13:02:37 GMT

Hi Rodrigo,

try below:

=if(GetSelectedCount(BillDate)=0, Year(Max(BillDate)))

Mean if nothing is selected in BillDate than it will take max year, which is 2013, else your selection.

will it help...?

and are you selecting one value at a time in slider? or a rang of value?

Re: Default value on slider

rodri_morales — Wed, 02 Oct 2013 13:12:05 GMT

It doesnt work. I'm selecting one value or a range. There is a picture of the properties of the slider:

Re: Default value on slider

DavidFoster1 — Wed, 02 Oct 2013 13:17:51 GMT

I would need to double check this but if you use a variable and preset that variable with a value (i.e. 2013) then the slider should start at that value. You can then utilise that variable in your expressions.

Re: Default value on slider

rodri_morales — Wed, 02 Oct 2013 13:36:06 GMT

I use the variable BillDate from a data base, how can I preset the value?

Re: Re: Default value on slider

DavidFoster1 — Wed, 02 Oct 2013 13:46:02 GMT

I think BillDate is a field not a variable.

Have a look at the test below.

Re: Default value on slider

rodri_morales — Wed, 02 Oct 2013 13:48:20 GMT

I'm working on the free edition of qlikview, I cant see your project. BillDate is a attribute from a database.