Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
MONTH(actual_bill_date) ActBillMo is the SQL line which results in the 1-12 numbers.
Month(ActBillMo) as ActBillMo returns only Jan & Dec
Try this instead
Month(Date#(ActBillMo, 'M')) as ActBillMo