topic How to set default range for slider on startup? in QlikView

How to set default range for slider on startup?

Wed, 06 Mar 2013 16:10:05 GMT

Dear Qlikview developers,

I'm building a dashboard where I need to give a slider a default range when the document is opened. I already now that I can use Document Event Triggers (OnOpen > Select in Field for example) I apply this technique for a listbox which holds the days in a week. But now I want to give my slider its default range. Unfortunately I don't know exactly how to accomplish this. I already searched the forum for this problem. But didn't find any topic which gives a clear-cut answer to my specific problem.

Below is a screenshot of the slider.

The slider is attached to a field named Cofely.Hour and represents the amount of hours in a day. I want to make sure that when the document is opened the range 8 - 18 is selected as default.

Added Qlikview file

Re: How to set default range for slider on startup?

Gysbert_Wassenaar — Wed, 06 Mar 2013 17:10:46 GMT

Add two Set Variable actions to the OnOpen document trigger to set the values of the variables used in your slider to the values you want.

Re: How to set default range for slider on startup?

Wed, 06 Mar 2013 20:24:14 GMT

Do you mean that I need to assign 2 variables to my slider, in stead of the datafield "Cofely.Hour"?

I've added the qlikview file as attachement now.

The reason why I use Cofely.Hour for the slider is because the slider is used to narrow down the dataset, which belongs to a specific Alternate State (TW1 or TW2) Then difference scatterplots can be made according to the specific dataset (TW1 or TW2).

If I replace Cofely.Hour with 2 variables, my dataset will not be narrowed down anymore, am I right? I added my Qlikview file for clarification.

For example, In the last chart on the left you will find a bunch of expressions. The expression named GasconsumptionPerHour_Monday_Period_Hour, shows the gasconsumption on monday, where the period is determined by the slider. The expression is as follows:

Avg({<Calendar.WeekDay = {'ma'},Cofely.Hour ={">=$(=Min(Cofely.Hour)) <=$(=Max(Cofely.Hour))"}, Calendar.DayYear= >}Cofely.Gas)

If I replace Cofely.Hour in my slider-settings, the expression wont fit anymore, the line isn't drawn anymore (for the specified period) and the dataset isn't narrowed down anymroe.