topic Re: Creating a filter with Input Box in QlikView

Creating a filter with Input Box

Thu, 02 Oct 2014 18:20:52 GMT

Hello again,

I am trying to create an input box or some kind of tool that will filter my values. Maybe sales totals. For instance I have the sales totals in a straight table and would like to filter values instantly with the help of a tool. Any suggestions for this? I am just going off of excel since this is easy with excel. Below is an idea of what I want to do. Sales Totals is summing the values sales amounts not quantities btw. It is a custom expression entered into that table.

Any suggestions?

Re: Creating a filter with Input Box

Thu, 02 Oct 2014 18:29:59 GMT

You could add a new list box with an expression field and use the Sales Totals expression for the values to display. You would have in wrap this in aggr() based on the dimensions in your table to get the unique totals.

Something like =aggr(sum(SalesAmounts),ITEM NUMBER,COLOR)

Re: Creating a filter with Input Box

Thu, 02 Oct 2014 18:32:49 GMT

So, it is not possible to have a handy input box for the values to be entered?

Re: Creating a filter with Input Box

Thu, 02 Oct 2014 18:42:18 GMT

I'm not sure about an input box, but you could still use the list box and add a search icon to the caption, then just type in the value there. You can even use >, <, >=, <= in the search icon to limit your Sales Amounts.

Re: Creating a filter with Input Box

Thu, 02 Oct 2014 19:15:07 GMT

Thank you.

I really wanted to find a way with input box but right now I am new to qlikview so I guess that is beyond my knowledge.

Re: Creating a filter with Input Box

Thu, 02 Oct 2014 19:27:50 GMT

you can use calculated dimension instead of COLOR field (ex:

if(aggr(sum(sales),ITEMNUMBER, COLOR)>$(vSales),COLOR)

and create a input box with variable as vSales

Notes: you can have exact same expression instead of sum(sales) in aggr