topic filter data based on input box in QlikView

filter data based on input box

Tue, 24 May 2011 12:06:54 GMT

Hi all,

i've a table like this (in script editor):

Branch, Date2, Sales, NoNew

1, 03/06/2009, 300, 1

1, 01/02/2010, 100, 2

1, 02/02/2010, 120, 3

2, 01/02/2010, 200, 4

2, 02/02/2010, 150, 1

in layout i've an input box where i type a date. Based on this input i want restrict my data: dates >= input date

So i create an event trigger on variable, but i don't know how to create the condition in the expression. I'm only able to create this condition: dates = input date

Re: filter data based on input box

Anonymous — Tue, 24 May 2011 12:24:57 GMT

Hi fiemazzo,

You can use the below mentioned expression to solve your issue

=sum(If (Date2 >= '$(vDate)', Sales))

I have attached sample application for your reference.

Br,

Narayanan

filter data based on input box

ToniKautto — Tue, 24 May 2011 12:29:41 GMT

I would use a Calendar object instead for the actual selection, to make the user experience a bit nicer.

Re: filter data based on input box

Tue, 24 May 2011 12:38:34 GMT

Thx Narayanan for your reply, your solution works fine but i found a way to solve the problem using this in my expression: ='>' & '$(var)'