Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Jennerz
Contributor
Contributor

Create a slider using data table value

Hey all,

I am trying to make a slider that uses one value "Price" that is from one of my data tables I've loaded in.

The slider will affect a scatterplot containing Equipment Name, Ordered Equipment Counts, and Estimated Shipping Time in Days, which uses data from that same table as the Price value.

Is there a way to do this without crazy variable work? The data table used for the aforementioned values affects a lot of other graphs. 

Labels (1)
1 Reply
chriscammers
Partner Ambassador
Partner Ambassador

I  hate to say this but I think you are going to be out of luck without at least some variables.

There are some add-on extensions that would do what you want.

I would like to offer a solution that won't be too crazy with variables but it is definitely not a slider.

You're going to need

three variables vMinVal, vMaxVal, and vSelectionString

Put vMinVal and vMaxVal in a couple of input box objects(in the Extensions/dashboard bundle)

set the value for vSelectionString to ='>=' & vMinVal & '<=' & vMaxVal

Now you can do a couple of things...

If you only want to effect the results of the scatter plot then add set analysis to your expressions like this {<Price = {"$(vSelectionString)"}>}

or if you want to set the selection on the price field you'll need to add a button to set the selection

you have to use the "Select values matching search criteria"

in the value field use =vSelectionString

Whatever you decide you may want to hop over to the ideation section and suggest the slider feature

 

Best of luck.