topic Re: Dynamic Filtering in QlikView

Dynamic Filtering

Wed, 07 May 2014 06:00:15 GMT

Hi All,

I would like to know how achieve the following requirement in qlikview which is straight forward in traditional BI tools.

Business user wants to have a text box or input box where he can enter or select the amount to filter the straight tables.

He is looking for something like sales >1000.

Thanks,

Re: Dynamic Filtering

swuehl — Wed, 07 May 2014 06:37:08 GMT

You can use such filters on each list box, just click the header and start typing.

On a list box with field SalesAmount:

> 100

On a list box with field Customer:

=sum(SalesAmount)>100

Re: Dynamic Filtering

its_anandrjs — Wed, 07 May 2014 06:46:09 GMT

You can use Input box for filter the Sales like

Eg:-

Create a variable

Let vTop = 0;

LOAD * Inline

[

Customer,Sales

A,1000

B,2000

C,3000

D,5000

E,4000

];

And then create a input box with variable vTop

And create a straight table

Dimension:- Customer

Expression:- sum({< Sales = {'>=$(vTop)'} >} Sales)

and in input box enter the value to sort the sales

Re: Dynamic Filtering

Wed, 07 May 2014 21:58:42 GMT

Thank you so much for your help.

Cheers

Re: Dynamic Filtering

Thu, 08 May 2014 00:28:01 GMT

Hi anand chouhan..Your solution worked perfectly but I have 1 more requirement on top of it. My fact grain is at item level where as my user wants to look the sales per order> certain amount. Can you please help me with using aggr function with set analysis

Thanks,

Re: Dynamic Filtering

jagan — Thu, 08 May 2014 01:49:43 GMT

Hi,

Try like this

sum({< OrderNumber= {'>=$(=Sum(Sales) > vTop)'} >} Sales)

Hope this helps you.

Regards,

Jagan.

Re: Dynamic Filtering

Thu, 08 May 2014 01:55:20 GMT

Hi Jagan Mohan..

Thank you for your reply. I tried but it didn't work. I am getting all 0's.

Thanks,

Re: Dynamic Filtering

jagan — Thu, 08 May 2014 01:56:37 GMT

Hi,

Can you attach sample file?

Regards,

Jagan.

Re: Dynamic Filtering

Thu, 08 May 2014 02:41:12 GMT

Hi Jagan,

After tweaking the expression a bit I got it worked.

From:

sum({< OrderNumber= {'>=$(=Sum(Sales) > vTop)'} >} Sales)

To:

sum({$<OrderNumber= {'=Sum(Sales) > vTop'} >} Sales)

Thanks,