Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Filter data range with variables in qlikview slider object

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

4 Replies
Partner
Partner

Re: Filter data range with variables in qlikview slider object

see attached

Highlighted
bbi_mba_76
Valued Contributor

Re: Filter data range with variables in qlikview slider object

Hi,

try

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

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

    ,1,0)

neetha_p
Honored Contributor

Re: Filter data range with variables in qlikview slider object

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

MVP
MVP

Re: Filter data range with variables in qlikview slider object

maybe this?

left all sales, right filtered (with slider) sales

1.jpg

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