topic Re: Slider, to exclude data values in QlikView

Slider, to exclude data values

marcus_steggall — Wed, 25 Nov 2020 16:16:04 GMT

Afternoon all, hope you're well.

So I have a dashboard showing client name, with revenue amounts, plus hours.

I've added a slider based on a min variable, so colleagues can select to remove clients less than a certain total.

For example, in the attached I have Whisper Power showing 349.50.

So when you move the slider to along to a minimum of 1000, this line should disappear.

But for some reason, even though the revenue goes to zero, the hours then change to say -1.00?

Any help, would be much appreciated.

marcus_sommer — Wed, 04 Apr 2018 14:54:29 GMT

I think your second expression should be look like:

sum({<Client_Name={"=Sum(Revenue)>=$(min)"}>} Worked_Hours)

- Marcus

sunny_talwar — Wed, 04 Apr 2018 14:58:46 GMT

It shows -1 because your true condition is this

if(sum({<Client_Name={"=Sum(Revenue)>=$(min)"}>} Revenue) = 0,

sum(Worked_Hours)=0,

sum(Worked_Hours))

and for this particular client Sum(Worked_Hours) = 0... which is true and true in QlikView is -1. What would you like to see?

boorgura — Wed, 04 Apr 2018 17:27:01 GMT

Just use this for hours expression:

if(sum({<Client_Name={"=Sum(Revenue)>=$(min)"}>} Revenue) = 0,

sum(Worked_Hours))

marcus_steggall — Thu, 05 Apr 2018 09:24:17 GMT

From one Marcus to another, good name

Many thanks, that was a quick and easy solution it seemed.

I have one concern, using this way that i've noticed.

From the attached qvd again, note i have this filtered on a particular client at an amount of 5,000

So if you move the slider along, from 4,000 to 5,000 this should remain.

But for some reason, it disappears!

Any idea, as it seems to do this for a handful of clients?

Nice one

marcus_sommer — Thu, 05 Apr 2018 10:00:46 GMT

It's a rounding topic because your result isn't 5,000 else 4,999.9....:

but by including a roundig like the following it worked:

sum({<Client_Name={"=round(Sum(Revenue))>=$(min)"}>} Revenue)

More to this behaviour could you find here: Rounding Errors.

- Marcus

marcus_steggall — Thu, 05 Apr 2018 13:00:05 GMT

of course rounding

excellent, now this slider is working like a dream.

Many thanks pal, exactly what I required