topic Re: Filter on Dimension Field using input box in QlikView

Filter on Dimension Field using input box

vijayit43 — Wed, 23 Apr 2014 14:01:03 GMT

Show those employee which Amount is greater than given input box

Re: Filter on Dimension Field using input box

cfz — Wed, 23 Apr 2014 14:09:13 GMT

Hi Vijay,

Please find attached an example.

I hope it helps.

Carlos

Re: Filter on Dimension Field using input box

bbi_mba_76 — Wed, 23 Apr 2014 14:09:38 GMT

Hi,

if you have a chart you could use an expression like if(sum(Amount)>v_InputBox, sum(Amount)) and use the suppress when value is null, or add it as calculated dimension.

Re: Filter on Dimension Field using input box

vijayit43 — Wed, 23 Apr 2014 14:15:58 GMT

Where is attached File???

Re: Filter on Dimension Field using input box

cfz — Wed, 23 Apr 2014 14:17:13 GMT

Just below the text in the comment.

Re: Filter on Dimension Field using input box

MK_QSL — Wed, 23 Apr 2014 14:17:50 GMT

Use below script..

====

Load * Inline

[

Customer, Sales

A, 100

B, 120

C, 200

D, 150

E, 160

];

====

Create a variable vTOTAL and keep it in Input Box

Create a straight table

Dimension

=IF(Aggr(SUM(Sales),Customer)>=$(vTOTAL), Customer)

Tick Suppress When Value is Null

Expression

SUM(Sales)

Now you can change the value of vTOTAL in input box and can see it's effect of Straight Table...