topic [] Question about a Month-Year format [] in QlikView

[] Question about a Month-Year format []

Anonymous — Wed, 26 Jan 2011 12:21:20 GMT

Dear experts,

I have a master calender with a field [YearMonth]
In an other table I have the fields [Year] and [Periode]

I am trying to link the table to the calender by combining the [Year] and [Periode] field as [YearMonth]
This works but both fields [YearMonth] have a different format and so the data does not match.

The [YearMonth] form the master calender is generated this way:

date(monthstart(Date), 'YYYY-MM') AS YearMonth,

And from the other table this way:

(Year&'-'&Periode) as YearMonth,

Both generate the same information only the [YearMonth] from the calander is alinged to the left and from the other one is alinged to the right.

The question is: How do I get (Year&'-'&Periode) into a (date() 'YYYY-MM'))-format?

[] Question about a Month-Year format []

hector — Wed, 26 Jan 2011 13:12:09 GMT

Hi, with the date you only are formating the value, but internally still have the day (in this case the 1st of each month), so try this

date(makedate(Year,Periode),'YYYY-MM') as YearMonth

Periode must be a value between 1 - 12

Hope this helps

Rgds

[] Question about a Month-Year format []

Anonymous — Wed, 26 Jan 2011 13:21:58 GMT

Yes Perfect! Just what I need.

Thanks

topic [*] Question about a Month-Year format [*] in QlikView

[*] Question about a Month-Year format [*]

[*] Question about a Month-Year format [*]

[*] Question about a Month-Year format [*]

topic [] Question about a Month-Year format [] in QlikView

[] Question about a Month-Year format []

[] Question about a Month-Year format []

[] Question about a Month-Year format []