Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Input Box Filter Based on Expression

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

12 Replies
sunny_talwar

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

Not applicable
Author

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

sunny_talwar

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