topic listbox and variables in QlikView

listbox and variables

t_hylander — Thu, 18 Aug 2011 10:04:03 GMT

Hi

Ive got a variable containing a date, vLastDate.

I then have in my database a couple of lines looking similar to this;

Place1, 2010-01-01

Place1, 2010-02-10

Place2, 2010-02-10

Place3, 2010-02-10

Place2, 2010-03-04

Place4, 2010-03-04

...

What I want is that when I load the App a listbox should only show the places with the same date as vLastDate.

Its no problem if I select a date manually, but cant get it to work with a expression in the listbox.

Shouldnt be too hard if you know how

Thanks in advance!

listbox and variables

rahulgupta — Thu, 18 Aug 2011 10:55:03 GMT

try something like:

Place,Date

Place1, 2010-01-01

Place1, 2010-02-10

Place2, 2010-02-10

Place3, 2010-02-10

Place2, 2010-03-04

Place4, 2010-03-04

take a list Box:

In that write an Expression:

=if(Date=vLastDate,Place)