topic Re: Selecting the dates in Two List Boxes in QlikView

Selecting the dates in Two List Boxes

rajkumarb — Thu, 22 Jan 2015 08:39:45 GMT

Hi Experts

I Have an Issue in selecting date fields in Two list box, if a select a particular date field in one list box I want the other date field in another list box to be selected as well, How Can I do this, Please advise

Re: Selecting the dates in Two List Boxes

Gysbert_Wassenaar — Thu, 22 Jan 2015 08:54:57 GMT

On the Triggers tab of the Document Properties window add a Select in Field action to the OnSelect field trigger of the first field. Use as target field the name of the second field and as search string the name of the first field.

Re: Selecting the dates in Two List Boxes

rajkumarb — Thu, 22 Jan 2015 10:04:27 GMT

HI Gysbert

Thank You for your Answer

I did that in the way you mentioned

MY first field is Dedate and the object Id is LBO2

My Second Fiels is Saledate and the object Id is LBO9

on the field events trigger -> Dedate -> on select-> Select In Field -> Field ->LB02 & Search String -> LBO9

And its not working Please advice

Re: Selecting the dates in Two List Boxes

kuba_michalik — Thu, 22 Jan 2015 10:11:23 GMT

Don't use listbox object's IDs, use field names.

Re: Selecting the dates in Two List Boxes

rajkumarb — Thu, 22 Jan 2015 10:22:37 GMT

Hi Jackub

I Changes it to Field Name

Its not Working, Any suggestions

Re: Selecting the dates in Two List Boxes

kuba_michalik — Thu, 22 Jan 2015 11:14:24 GMT

Eh, you are right of course, you can't just input another field's name as a search string...

Use this here abomination:

='=Only({<Saledate =$::Dedate>}Saledate )'

as the search string instead. There is probably a simpler way I can't remember at the moment

Have a look at the attached example if in doubt (trigger set for F1 OnSelect in the example)

Re: Selecting the dates in Two List Boxes

rajkumarb — Thu, 22 Jan 2015 11:31:13 GMT

Hi Jakub

Thank You

It Worked

Re: Selecting the dates in Two List Boxes

Anonymous — Thu, 22 Jan 2015 12:01:37 GMT

Hi Raj Kumar,

try like this

Triggers -->Select the field which --->onSelect -->Action-->Selectpossible --> enter the field name which you want the data to be selected -->ok