topic How to link Multiple date fields to one date in one table in QlikView

How to link Multiple date fields to one date in one table

Fri, 15 Jun 2012 06:36:24 GMT

Hi,

I Have Data like this

Assign Date open open_date close close_date Isuue_status

12/4/2012 abc 11/4/2012 abc 12/4/2012 closed

Like this i have data for caculation of open : i use opendate

for calculation of close: i use close date

i need a pivot table with single date or month field across dates ie

Months Open_count close_count

Jan-12 12 10

feb-12 10 0

Like this i need one date field but for calculation of open_count we should use open date and close_count we should use close_count

Regards,

Madhukumara

Re: How to link Multiple date fields to one date in one table

Fri, 15 Jun 2012 06:52:19 GMT

Hi,

As per my understanding you want to select a period like a Month say Jan-2012 and you want to see the Open Count and Close Count for this period. So do one thing-

Table:

open,

open_date,

Isuue_status,

open_date as Date

concatenate

//same table

close,

close_date as Date ,

Issue_status

now select this Date field or link this to a calendar u ll get both open n clased data.

Thanks n Regards

Apurva

Re: How to link Multiple date fields to one date in one table

Fri, 15 Jun 2012 06:58:38 GMT

Hi,

How to link dates and same table we shoud concatenate?

regards,

madhukumara

On Fri, Jun 15, 2012 at 12:22 PM, Apurva ... <

Re: How to link Multiple date fields to one date in one table

Fri, 15 Jun 2012 07:02:17 GMT

Hi,

there is a keyword CONCATENATE use this. suppose your table name is A.

load *,

open_date as Date

from A;

CONCATENATE

load *,

close_date as Date

from A;

regards

Apurva