topic Re: Variables in QlikView

Variables

Mon, 01 Feb 2016 10:02:31 GMT

Hi All;

I have 2 fields : planned date (First Pick Plan Date Start) and an actual date (First Pick Arrival Date).

First Pick Plan Date Start	First Pick Arrival Date
18/01/2016 06:58	18/01/2016 16:04
18/01/2016 11:54	18/01/2016 08:47
18/01/2016 16:50	18/01/2016 22:10
18/01/2016 21:46	20/01/2016 01:25

User will select planned date i.e. (First Pick Plan Date Start) on the selections.

When user selects (First Pick Plan Date Start) for example 18/01/2016, l want to create a variable that help me to show all loads with a (First Pick Arrival Date) that is the same with one on current selection (First Pick Plan Date Start) i.e. 18/01/2016.

Please assist.

Regards;

Moses

Re: Variables

sunny_talwar — Mon, 01 Feb 2016 10:54:39 GMT

When user selects (First Pick Plan Date Start) for example 18/01/2016, l want to create a variable that help me to show all loads with a (First Pick Arrival Date) that is the same with one on current selection (First Pick Plan Date Start) i.e. 18/01/2016.

Not really sure what the variable will sow when you select 18/01/2016. Can you elaborate on your desired result?

Re: Variables

Mark_Little — Mon, 01 Feb 2016 10:57:54 GMT

Hi,

As Sunny has suggested some more information would be helpful.

From the limited information we have, i would think that you could achieve this without a variable.

If in script you strip just the date values from the First Pick Plan Date Start field and use this a selection it would show all associated First Pick Arrival Date.

Mark

Re: Variables

asgardd2 — Mon, 01 Feb 2016 11:49:05 GMT

Please see the attached example and explain, that you want to show, through new variable.