Discussion board where members can get started with QlikView.
I am havig problems concatenating and joining QVDs becasue of dates.
I have two (or more) QVDs, all of them have dates and its years and months:
It is possble to have problmes joining or cancatenating them acording to their keys?
load Month(qvd1month) as m_qvd1month
load Num(qvd1month) as n_qvd1month
QVD3 should return values from 1 to 12, but it return only 1,7 and 12. I want to preserve the month name but the join is not correct because of the problem I just described.
Please any help.
Tank you in advance.
Also your QVD2 results are kind of strange (Month of a month should not return a month (or more precisely, not a range of months).
Could you please upload a QVD that shows this qvd1month field?