topic Re: one small scenario ? in QlikView

one small scenario ?

satheshreddy — Mon, 26 Jan 2026 16:26:21 GMT

hi experts,

i have small requirement

i have 2 list boxes these 2 list boxes having Date fields with same data,

my requirement is if select one date in one field at that time 2nd field to display

current selections>dates

any one explain using set analysis.

thanks

s reddy

Re: one small scenario ?

sunny_talwar — Tue, 14 Jul 2015 15:17:08 GMT

Using triggers and alternate state, you might be able to get what you want. I have sample for you to look at.

HTH

Best,

Sunny

Re: one small scenario ?

MK_QSL — Tue, 14 Jul 2015 15:17:17 GMT

PFA

Edit: little correction in trigger

Re: one small scenario ?

maxgro — Tue, 14 Jul 2015 15:20:25 GMT

maybe with a trigger, see attachment

Re: one small scenario ?

satheshreddy — Tue, 14 Jul 2015 16:44:37 GMT

hi sunindia,

please explain step bye step because am learner so if you possible let me explain.

thanks

s reddy

Re: one small scenario ?

sunny_talwar — Tue, 14 Jul 2015 16:53:01 GMT

1. Script (Courtesy Manish‌)

Table:

LOAD Date(Floor(Rand() * 365 + Today())) as Date

AutoGenerate 10000;

2. Created a list box for Date

3. Created a alternate state from document properties

4. Created a second list box in alternate state using an expression

5) Created a trigger which sets the vMaxDate's value = Max(Date)

and TAAAAADAAAA you are good to go...

HTH

Best,

Sunny

Re: one small scenario ?

satheshreddy — Tue, 14 Jul 2015 17:34:02 GMT

hi,

please tell me a little correction on trigger, my qlikview is personal edition please write the correction.

thanks

s reddy

Re: one small scenario ?

MK_QSL — Tue, 14 Jul 2015 18:19:32 GMT

Use below in your script.

===============================================================

LOAD

Date(Today() + Floor(RAND()*(AddYears(Today(),1) - Today() + 1))) as InvoiceDate

AutoGenerate 1000;

LOAD

Date(Today() + Floor(RAND()*(AddYears(Today(),1) - Today() + 1))) as Date

AutoGenerate 1000;

===============================================================

Now consider that you have two list boxes.. one for Date and 2nd for InvoiceDate.

Date list box is straight forward but any date you change/select in Date list box will give InvoiceDate accordingly.

InvoiceDate automatically get selected which are greater than Date which is selected.

Follow below steps to get this result.

Create two list box

1) Date

1) InvoiceDate

Go to Settings -- Document Properties -- Triggers -- Field Event Triggers

Select Date -- On Select ---

Add

Field

InvoiceDate

Add

Select in Field

Field

InvoiceDate

Search String

='=InvoiceDate>=Date'

Same action add for onChange trigger on Date field.

Hope this helps..