topic Re: Help for a cursor interval in QlikView

Help for a cursor interval

Fri, 18 Jul 2014 12:40:44 GMT

Hello,

I want to create a cursor with a variable.

The problem is, i dont know how i can have only 2 choices of values : 1 or 1000.

When i put an interval of 1000, i can choose every single value from 1 to 1000.

When i put an interval of 999, i can choose 1, 999 and 1000.

But if i put the min value to 0 with 1000 as interval, it works, i can only choose 0 or 1000. So i don't know how to get what i want...

Can someone help me please?

Thanks,

Regards,

Loïc

richard_pearce6 — Fri, 18 Jul 2014 12:48:18 GMT

Why not use a couple of button acctions to control the variable rather than a slider?

Fri, 18 Jul 2014 12:51:41 GMT

Because this is funnier for the users

richard_pearce6 — Fri, 18 Jul 2014 12:57:49 GMT

Fair enough.

Here's a solution.

vSlider = Set up the slider so the min is 0, the max is 1 and the step is 1

vSliderCals = vSlider * 999+1

Replace the slider min and max values (visible to user) with text boxes with your 1 & 1000 figures in......

They will never know 😉

richard_pearce6 — Fri, 18 Jul 2014 13:01:26 GMT

qvw

Fri, 18 Jul 2014 13:10:17 GMT

Lol

Thanks for your idea, this is quite funny.

But I use the value of the variable in many expressions like: =sum(Quantity)/$(Var)

If the Value is 0 or 1, my expression will be false.

richard_pearce6 — Fri, 18 Jul 2014 13:28:19 GMT

Not if you use vSliderCals instead of Val.

This variable will be either 1 or 1000 depending on the slider possition. See the qvw I uploaded for the example.

Rich