Discussion Board for collaboration related to QlikView App Development.
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 :
Transaction Table Field :
Concanate script :
'MS Tes' as Transtype,
MsDate as Date,
DATE#(month(MsDate)& '-' & year(MsDate), 'MMM-YYYY') AS MonthYear,
MONTH(MsDate) as Month,
YEAR(MsDate) as Year
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