Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Slider to select a field

Hi Experts,

I am trying to create a slider in Qliksense which will select the values in a field.

I have an 'Hour' field in my table which has values ranging from 0 to 23.

Now, i need to create a slider with this Hour values 0 to 23.

whenever i move the slider to a value, it should select 'Hour' field and this selection should impact the other charts in my sheet.

Is it possible? If so, can you please guide me on how to do this?

1 Solution

Accepted Solutions
karthikoffi27se
Contributor III

Re: Slider to select a field

Hi Rajendran,

I don't think you use the right extension, Please follow my link above.

I have attached the sample file with your desired output.

Many Thanks

Karthik

11 Replies
karthikoffi27se
Contributor III

Re: Slider to select a field

Hi Rajendran,

You can use this extension for variable slider.

http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8

Include that variable value in your formula.

Many Thanks

Karthik

Not applicable

Re: Slider to select a field

i have this extension already.

but i dont know how to achieve my requirement.

can you please explain it step by step?

also, can you please explain how to include that variable value if my expression in a chart is sum(sales)

mayuresh_d
Contributor

Re: Slider to select a field

hi,

use expression as "sum({<Hour={'$(vHour_var)'}>}sales)"  where "vHour_var" will be your variable..

now in slider set data value as an variable then min and max value will be 0 and 23 respectively.

you will get what you want as an output.

Thanks

Mayuresh

Not applicable

Re: Slider to select a field

Hi Mayuresh,

I tried the way as you said but it is not working.

i have attached the sample qvf which i m working on.

If you please correct it on this sample that would be great.

karthikoffi27se
Contributor III

Re: Slider to select a field

Hi Rajendran,

I don't think you use the right extension, Please follow my link above.

I have attached the sample file with your desired output.

Many Thanks

Karthik

Not applicable

Re: Slider to select a field

Hi Karthik,

Thank you so much.

i did the same way in my original app. but the charts are displaying values only when the slider is set above 10.

but there is data even for Hour 0. i dont know what i m doing wrong. please help

can you please tell me why the variable is defined as sum(1)? reason?

_k0zm0_2
New Contributor III

Re: Slider to select a field

The example of karthikoffi27sep worked for me:

2017-08-07 12_57_47-Qlik Sense Desktop.png

I've added a table with:

  • Dimension:
    • Date
    • Hour
  • Measure:
    • sum(Sales)
  • Order by:
    • Date
    • Hour
    • Sum(Sales)

I've checked the 'Slider Label' option in the object of qsVariable extension

Not applicable

Re: Slider to select a field

Yes it is working in that example.

but not in my actual app. the charts are displayed only if the slider value is above 10 which is wrong.

there should be some data even if the slider is 0

_k0zm0_2
New Contributor III

Re: Slider to select a field

Can you share some code or screenshot?

That's a strange behaviour if there is no condition somewhere