topic Not able to format month in proper manner. in QlikView

Not able to format month in proper manner.

deepakqlikview_123 — Fri, 13 Jun 2014 05:46:53 GMT

Hi all,

Please find attachment.

Currently I am not able to get ,moonth for dec 2012 and some values can you please suggest how to get the month properly.

Thanks

Re: Not able to format month in proper manner.

tresB — Fri, 13 Jun 2014 05:52:22 GMT

You mean 'Dec' is not selectable for the year 2012? If so, that is because there is no data for Dec-2012. If you still want the Dec or such months to appear selectable, you have to work - create master calendar in the script; populate zero values for missing month data.

Re: Not able to format month in proper manner.

SergeyMak — Fri, 13 Jun 2014 05:58:19 GMT

Hi,

As I see it's because you don't have data for dec 2012

You will have dates for dec 2012, if you add Calendar table (you can find examples in the community), but you still not have the values for this month