topic Creating 'MonthYear' from two fields in QlikView

Creating 'MonthYear' from two fields

Tue, 01 Mar 2011 13:38:48 GMT

Greetings all!

Am trying to create a MONTHYEAR field from the two separate fields, but the result is undesired.

As far as I could understand, the result should be:

200901
200902
200903
200904
...

And the same to all other years... the code I'm using for that follows:

Year & DATE(Month,'MM')

And I could not find anything different from that through the tutorials and F1 in QV...

Any thoughts?

Thank you again!!!

Tue, 01 Mar 2011 13:48:25 GMT

Use DATE(YEAR,MONTH)

fIBER9906

Tue, 01 Mar 2011 13:56:28 GMT

It could be beter use monthname(date(YEAR,MONTH))

Tue, 01 Mar 2011 14:06:48 GMT

Just to clarify, I must replace de MONTH and YEAR by my fields, correct?

Tue, 01 Mar 2011 14:13:46 GMT

Tried both, and these were the results...

Any other thoughts? I'm trying create this field in the format YYYYMM to link it to a fact table, therefore, its crucial...

Thanx all!

Tue, 01 Mar 2011 14:26:06 GMT

Yes, of course. Your name fields are equal to arguments. Try this and tell me.

Fiber906

Tue, 01 Mar 2011 14:35:09 GMT

Hello fiber9906! These are the results! Any other thoughts???

Tue, 01 Mar 2011 20:28:49 GMT

Excuse me Thiago for not to reply as quickly as you need. I was mistaked; look at attached file and I hope it is what you are looking for:

Wed, 02 Mar 2011 13:29:53 GMT

Thank you for the reply!

I have found out the solution for it last night...

DATE(MAKEDATE(Year, Month), 'YYYYMM')

It has brought me the expected result (200901, 200902, ...) Have seen your file, and it might be very useful in the future.

Thx for the info exchange! Always a pleasure!