Sort monthnames on monthnumber

[paulberendts]

I have a SQL table with three integer columns, Year, month and total. I can show that in a 'Draaitabel' with month horizontal and year vertical. Horizontal needs to be sorted on month (1,2,3). Now I want not to show the month numbers, but the month names. I can do that  with the Longmonthnames, but then the sorting goes all wrong. Houw can I sort the monthnames on their 'integer' values?

[tresesco]

Check Uploading a Sample

[paulberendts]

Thanks,

Here is a qvw test file.

What i'm looking for is:

-A column for each month of the year (evenif there are no input records for thes month)

-The columns sorted in the correct sequence (jan-feb-mar etc.)

Thanks,

Paul Berendts

[tresesco]

Probably you have forgotten to attach the file. However, now that you say:

Paul Berendts wrote:

..-A column for each month of the year (evenif there are no input records for thes month)

I guess you have to use a master calendar to generate all the missing dates/months. Have a look here:

Master Calendar Generation Script‌

Generating Missing Data In QlikView

Generating Missing Data In QlikView

[paulberendts]

Thanks,

Here is a qvw test file.

What i'm looking for is:

-A column for each month of the year (evenif there are no input records for thes month)

-The columns sorted in the correct sequence (jan-feb-mar etc.)

Thanks,

Paul Berendts

[tresesco · Accepted solution]

Try calculated dimension like:

=Month(MakeDate(1,Maand))

[paulberendts]

Thank you, exactly what I was looking for.