[ASK] Anomaly with concatenate function

Wed, 25 Jun 2014 07:28:11 GMT

Hallo dear QV users..

i have one or two question to ask.

I have a master table, and a concatenated table for transaction table.

Master Table field :

[Entry ID]	ID	MsDate	Quantity	Type
MS-1	1	03/31/13 12:02 PM	192	MS1
MS-2	2	03/31/13 05:53 PM	792	MS1
MS-3	3	04/30/13 08:12 AM	0	MS1
MS-4	4	04/30/13 08:12 AM	84	MS1
MS-5	5	04/30/13 08:12 AM	336	MS1

Transaction Table Field :

[Entry ID]

TransType

Date

Month

Year

MonthYear

MS-1

MS Tes

04/30/13 12:02 PM

2014

Apr-2013

MS-2

MS Tes

04/30/13 12:02 PM

2014

Apr-2013

MS-3

04/30/13 08:12 AM

2014

Apr-2013

MS-4

04/30/13 08:12 AM

2014

Apr-2013

MS-5

04/30/13 08:12 AM

2014

Apr-2013

Concanate script :

Concatenate(Transaction)

LOAD

[Entry ID],

'MS Tes' as Transtype,

MsDate as Date,

DATE#(month(MsDate)& '-' & year(MsDate), 'MMM-YYYY') AS MonthYear,

MONTH(MsDate) as Month,

YEAR(MsDate) as Year

resident MPRODPLAN;

I've tried without concatenate function, and there's nothing wrong.

But when i use concatenate, missdate are appears.

My question is :

Why date for MS-1 and MS-2 in transaction table are different?

And how to fix this?

Many thx before

topic [ASK] Anomaly with concatenate function in QlikView

[ASK] Anomaly with concatenate function