topic Re: Finding Values with slider or input box in QlikView

Finding Values with slider or input box

Wed, 15 Jul 2015 16:44:30 GMT

I am trying to supplement a straight table that has Users and total spend along with multiple other fields in it. Is it possible to have a slider or input box (ideally both) that I type or slide to a value say $100, and it will show all the users that have $100 spend instead of changing the actual spend to $100?

Re: Finding Values with slider or input box

sunny_talwar — Wed, 15 Jul 2015 16:49:04 GMT

Probably this:

If(Yourexpression = $(vVar), yourexpression)

where vVar is based on your slider or input box object.

HTH

Best,

Sunny

Re: Finding Values with slider or input box

Wed, 15 Jul 2015 16:59:30 GMT

Embed that if statement in the straight table? and create a vVar for the slider or input box?

Re: Finding Values with slider or input box

sunny_talwar — Wed, 15 Jul 2015 17:00:24 GMT

Yes, I am trying to see if I can create a sample for you.

Re: Finding Values with slider or input box

sunny_talwar — Wed, 15 Jul 2015 17:03:34 GMT

See if the attached helps.

Best,

Sunny

Re: Finding Values with slider or input box

Wed, 15 Jul 2015 17:21:55 GMT

Thanks Sunny, I think this will work, but I want to show all users over $75, $100, $ 150 by the slider and input, sorry I didn't specify, this might make things more difficult?

Re: Finding Values with slider or input box

sunny_talwar — Wed, 15 Jul 2015 17:26:06 GMT

Change the expression to this:

=If(Sum(Value) >= vVar, Sum(Value))

Re: Finding Values with slider or input box

cbaqir — Fri, 11 Sep 2015 20:28:45 GMT

How would this work if you are using multi value in the slider? I need to enter a start and end date.

Re: Finding Values with slider or input box

sunny_talwar — Fri, 11 Sep 2015 21:09:06 GMT

‌Should be straight forward if I am thinking about it correctly.

If(Date >= vStartDate and Date <= vEndDate, yourExpression)

Re: Finding Values with slider or input box

cbaqir — Thu, 22 Oct 2015 17:05:34 GMT

Gantt and Straight table by Input Box Date Range

Sunny, Mind if I ask you to weigh in on this?