topic Re: Input Box Filter Based on Expression in QlikView

Input Box Filter Based on Expression

Tue, 07 Jul 2015 19:58:03 GMT

Hey guys,

Quick question

I have a dashboard with a pivot table. The pivot table has many dimensions and one Expression.

The expression is shown in %. I need to create an Input box where a customer can enter a % and it will filter based on the % they inputed..

Any idea's?

Thanks allot

Re: Input Box Filter Based on Expression

sunny_talwar — Tue, 07 Jul 2015 20:01:49 GMT

If you want to see rates above user inputs, you can try this

If(YourExpression >= UserInput, YourExpression)

Adjust the above expression according to your need.

HTH

Best,

Sunny

Re: Input Box Filter Based on Expression

Clever_Anjos — Tue, 07 Jul 2015 20:02:28 GMT

Use this type of expression

if(SUM(Value) >= vTextBoxVariable, SUM(Value))

Re: Input Box Filter Based on Expression

Tue, 07 Jul 2015 20:03:02 GMT

The main issue is i don't know how to filter with expression results in an input box. That was my question.

Re: Input Box Filter Based on Expression

sunny_talwar — Tue, 07 Jul 2015 20:05:06 GMT

The user will input a number which will be stored in a variable. Lets call the variable vVar and then you will test your expression to see if its above or below it and based on what you want show the value:

If(yourExpression >= $(vVar), yourExpression)

Does this help? if this is not what you want, can you explain with an example?

Re: Input Box Filter Based on Expression

Clever_Anjos — Tue, 07 Jul 2015 20:07:47 GMT

Please find attached

Re: Input Box Filter Based on Expression

sunny_talwar — Tue, 07 Jul 2015 20:12:38 GMT

I would try this:

=If(sum(stkqty)-sum(onorder)-sum(onpick) = $(vVar), sum(stkqty)-sum(onorder)-sum(onpick))

where vVar will equal 2 based on user input.

Re: Input Box Filter Based on Expression

Tue, 07 Jul 2015 20:16:49 GMT

Wow your so helpful my friend!

That worked great.. One more thing when i use this expression when nothing is selected nothing shows up in table how can i change this?

Re: Input Box Filter Based on Expression

sunny_talwar — Tue, 07 Jul 2015 20:18:20 GMT

Try this:

=If(Len(Trim($(vVar))) = 0, sum(stkqty)-sum(onorder)-sum(onpick), If(sum(stkqty)-sum(onorder)-sum(onpick) = $(vVar), sum(stkqty)-sum(onorder)-sum(onpick)))

Re: Input Box Filter Based on Expression

Tue, 07 Jul 2015 20:22:02 GMT

mhmm i used this expression and it stopped working altogether.

Re: Input Box Filter Based on Expression

sunny_talwar — Tue, 07 Jul 2015 20:30:16 GMT

Can you try this:

=Alt(If(sum(stkqty)-sum(onorder)-sum(onpick) = $(vVar), sum(stkqty)-sum(onorder)-sum(onpick)), sum(stkqty)-sum(onorder)-sum(onpick))

Re: Input Box Filter Based on Expression

Tue, 07 Jul 2015 20:35:18 GMT

user must enter 0 for everything to show is there a way to make it so ENTER nothing automatically shows 0?

It works though so that's great, thank you very much

Re: Input Box Filter Based on Expression

sunny_talwar — Tue, 07 Jul 2015 20:37:54 GMT

May be one of these two?

=If(sum(stkqty)-sum(onorder)-sum(onpick) = Alt($(vVar), 0), sum(stkqty)-sum(onorder)-sum(onpick)) or

=If(sum(stkqty)-sum(onorder)-sum(onpick) = If(Len(Trim($(vVar))) = 0, 0, $(vVar)), sum(stkqty)-sum(onorder)-sum(onpick))