Help Please - Use Specific Value in Expression

Sun, 18 Mar 2012 00:19:49 GMT

I have a list box with 3 items in it loaded from a table as so:

'ListBox'

Item1

Item2

Item3

I would like to create an expression where I display dates that only correspond to one of the items in the list box.

Straight Table currently displays the below regardless of item number selected:

Item1 1/2/2012

item2 2/2/2012

item3 3/2/2012

I only want to upon selecting item1 in my listbox to update the Straight Table to show only Item1 and associated date as listed below. How do i do this.

Item1 1/2/2012

Re: Help Please - Use Specific Value in Expression

tresB — Sun, 18 Mar 2012 06:33:57 GMT

Hello, what you want is expected to happen automatically provided your data model is correct. therefore have a look at your model.

script should be something like:

Load

ITEM,

DATE,

ITEM & ' ' &DATE as ItemDate

From .....table1;

now for this table, if you select item1 under ITEM, your ItemDate list would show only "Item1 1/2/2012".

Regards, tresesco

topic Help Please - Use Specific Value in Expression in QlikView

Help Please - Use Specific Value in Expression

Re: Help Please - Use Specific Value in Expression