topic Re: Month Name as text in chart dimension in QlikView

Month Name as text in chart dimension

martynlloyd — Tue, 25 Aug 2015 11:03:59 GMT

I'm using NPrinting to output a chart to a spreadsheet, my problem is that the month dimension is output as numeric (dual field).

I've tried using =SubField(MonthNames,';',KPIMonth) as my dimension, but it gives an allocated memory error.

Am I using the wrong syntax?

Regards,

Marty.

sasiparupudi1 — Tue, 25 Aug 2015 11:10:44 GMT

try

Month(KPIMonth)

Tue, 25 Aug 2015 11:13:21 GMT

That is a string function and it will not work on dimension as it will change it.

The best option is to make a non numeric dimension during load and use it as the dimension in your chart.

If the syntax of KPIMonth is a date syntax, then you can add the following field in your load

MonthName(KPIMonth) as New_KPIMonth,

and use New_KPIMonth in your chart.