Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
t_hylander
New Contributor III

listbox and variables

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!

Tags (2)
1 Solution

Accepted Solutions
rahulgupta
Contributor III

listbox and variables

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)

1 Reply
rahulgupta
Contributor III

listbox and variables

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)

Community Browser