Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
greend21
Creator III
Creator III

Converting Month Numbers Shows only Jan and Dec

We are using SQL to pull the month, which then gets loaded into Qlikview as the month number. When I try converting these to month name In Qlikview it will only show January and December even though all calendar months should be there. Do you know what is causing this?

1 Solution

Accepted Solutions
sunny_talwar

Try this instead

Month(Date#(ActBillMo, 'M')) as ActBillMo

View solution in original post

3 Replies
sunny_talwar

Can you show the month number field you get from SQL? and also, what do you do to convert it? I mean what script do you use?

greend21
Creator III
Creator III
Author

MONTH(actual_bill_date) ActBillMo is the SQL line which results in the 1-12 numbers.

Month(ActBillMo) as ActBillMo returns only Jan & Dec

sunny_talwar

Try this instead

Month(Date#(ActBillMo, 'M')) as ActBillMo