Filter data range with variables in qlikview slider object

[#1]

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!!!

[giakoum]

see attached

[bbi_mba_76]

Hi,

try

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

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

    ,1,0)

[Anonymous]

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

[maxgro]

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))