Dynamic Filtering

[#1]

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,

MC

[swuehl]

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

[its_anandrjs · Accepted solution]

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

[#4]

Thank you so much for your help.

Cheers

Mc

[#5]

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,

Mc

[jagan]

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

[#7]

Hi Jagan Mohan..

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

Thanks,

MC

[jagan]

Hi,

Can you attach sample file?

Regards,

Jagan.

[#9]

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,

Mc