topic Re: Filter data range with variables in qlikview slider object in QlikView

Filter data range with variables in qlikview slider object

Mon, 26 Jan 2026 18:19:17 GMT

Hi, I'm new in Qlikview and I'm having a problem with a report. I have Countries and Sales data and I've created two expressions: Sum(Sales) and Sum(Sales)/Sum(TOTAL(Sales)), the last in %. I'd like to create a Slider Object to select values into 4 ranges: 0-25%, 25%-50%, 50%-75% and 75%-100. I've tried to define two variables for min and max range value but I don't understand why the filter doesn't work.

Anyone can help me, please?

I've posted an example...Thank you so much!!!

Re: Filter data range with variables in qlikview slider object

giakoum — Fri, 06 Feb 2015 15:56:00 GMT

see attached

Re: Filter data range with variables in qlikview slider object

bbi_mba_76 — Fri, 06 Feb 2015 15:59:13 GMT

Hi,

try

=if((Sales/Sum(TOTAL(Sales))) >= Vmin

and Sales/Sum(TOTAL(Sales)) <= Vmax

,1,0)

Re: Filter data range with variables in qlikview slider object

Anonymous — Fri, 06 Feb 2015 16:56:59 GMT

Hi,

In slider object properties go to General Tab, here you will find the static step. check that option and set value as 25.

This will give you an increment of 25%, Next set vData variable = 25 set min variables = 0 and max variables = 100 in script

In slider object properties - general tab - assign min and max variables to min and max textboxes

assign vData variable in dimension limits tab - show only values that accumulate to text box of chart object.

Regards

Neetha

Re: Filter data range with variables in qlikview slider object

maxgro — Fri, 06 Feb 2015 17:53:02 GMT

maybe this?

left all sales, right filtered (with slider) sales

chart on the right has

dim

=if(aggr(sum(Sales)/Sum(TOTAL(Sales)),Country)>=Vmin

and

aggr(sum(Sales)/Sum(TOTAL(Sales)),Country)<=Vmax,

Country

)

expr

sum(Sales)/Sum(TOTAL(Sales))