qliksense Slide Range Min and Max

[#1]

Hello Community,

I have Profit% ranging from 0.0 to 200.00%, and I want to display in Slide  with min(profit%) and max(profit%) as a slide variable and able to display in chart or KPI avg(profit%) based on min(Profit%) and Max(Profit%) variables. can you please help on this.

Thanks

Rj

[arulsettu]

you can use variable extension. post sample qvf

[reddy-s]

Hi Raju,

You can make use of a range slider which updates a variable in qliksense. here is the link to download it:

GitHub - stefanwalther/sense-range-slider: Range Slider for Qlik Sense

[#4]

Hello sangram reddy,

I am using Range Slider, I am able to show vMin(profit%) and vMsax(profit%) values from database, but based on min and max slider selection I want able to display listing of min and max avg(Profit%)  details. I am attaching screen shot and sample data.

City	Sales	Profit%
Meduno	8	24%
Pollena Trocchia	4	65%
Bridgeport	10	29%
Nanded	7	91%
Airdrie	10	33%
Fontaine-Valmont	7	33%
Grand-Hallet	3	131%
Hawick	7	21%
Lochgilphead	4	56%
Nederokkerzeel	8	131%
Windermere	7	160%
Gölcük	7	5%
York	10	6%
Reading	1	7%
Reno	2	22%
Jackson	2	8%
Pforzheim	2	24%
Verdun	3	22%
San Vito Chietino	6	88%
Ludwigsfelde	7	36%
Bergeggi	10	62%
Vitry-sur-Seine	8	125%

[#5]

hello arul,

variable extension has only one variable to use. I want able to use min and max values from profit% value and based on min and max, I want to see only selected range profit% details,

Thanks

Raj

[ameydiwanji]

Hi Raju,

You have to create a measure accordingly which will respond to your slider.For eg. if you want your profit should be as a percentage of sales (eg. 20% of sales) then first crate a variable "percentage" with min value and max value.

After this you create a measure with an expression using the variable created.

So in the above example your measure will be ([Sales]*[percentage]) and apply.

This should work.

Thanks