topic Re: List box to select dates from two values in QlikView

List box to select dates from two values

Dayna — Tue, 29 May 2012 13:34:23 GMT

Hello All,

I was wondering how to achieve the following,.... I have two date fields, one for created and one for shipped. I was wondering whether it was possible to select a date (i.e. 01/01/2012) and for it to select results from the shipped_date and created_date? So it would select all possible rows of data? e.g.

PROD SHIPPED_DATE CREATED_DATE ID

A 01/01/2012 11/12/2011 1

B 31/01/2012 01/01/2012 2

A 02/01/2012 31/12/2011 3

In the above example, I would want to select 01/01/2012 and receive rows with the ID of 1 and 2...

Many thanks for your help!

Kind Regards,

Dayna

List box to select dates from two values

Tue, 29 May 2012 13:39:46 GMT

If the two rows are from different tables, you could alias both date columns with the same name, e.g. %DATE.

When you select a %DATE, both rows will appear in the selection.

List box to select dates from two values

Dayna — Tue, 29 May 2012 13:41:40 GMT

Hello, sadly not as I tried the same - there in the same table as they've been combined with a left join.

Re: List box to select dates from two values

Wed, 30 May 2012 08:52:16 GMT

Hi Dayna,

You could use the following:

LOAD

SHIPPED_DATE as %DATE,

Resident products;

Concatenate

LOAD

CREATED_DATE as %DATE,

Resident products;

By creating a list box for the %DATE column and a selection in this box, the correct rows will appear. Note that the created table will contain multiple rows for the combination of PROD, SHIPPED_DATE, CREATED_DATE, ID, because you've duplicated them.

However, as long as don't show the %DATE column, the duplicate rows will be ommitted in a table box.

Re: List box to select dates from two values

Anonymous — Wed, 30 May 2012 10:22:58 GMT

Hi,

Try this ..

Create island table contain Date field or create calendar object by using variable. Use same Date field or variable in expression.