Bar chart date format

[#1]

Hi,

I've made a bar chart however my axes is showing as a number corresponding to month, however I would like it to say the month itself.

For example: It is showing 1 as January, 2 as February, 3 as March etc..

I'd like the text instead of the number.

I've tried to change the format using an expression but it did not seem to work.

[Anil_Babu_Samineni]

Create Island table and use that field into Dimension

[#3]

such as this.. ?

LOAD * INLINE [

Num, Month,

1, Jan

2, Feb

...

12, Dec];

[passionate]

Hi Sharan,

1. Create a column in load script i.e 1=Jan; 2= Feb and so on.(Mapping load)

2. Use calculated dimension (Pick(Match))

But performance wise option 1 is best suited.

Cheers,

Pankaj

[passionate]

Best Practices says to use less Island tables

[#6]

Hi Pankaj,

Thank you. But do you know a way this can be done without loading the script, and instead within the chart itself.

I was thinking of using an expression such as

=Month(Date#(IssueDateMonth, MM”)

it says the expression is okay but does not apply the changes, any suggesstions?

[Anil_Babu_Samineni]

Only one report you want to show?

Qlik proved performance wise as well

Pick(Match(Month, 1,2,3,4,5,6,7,8,9,10,11,12), 'January','February','March','April','May','June','July','August','September','October','November','December')

[santhoo_san]

Hi,

I think you are working on QlikSense application and not QlikView. If you are working on QlikSense, then just go to Appearance>x-axis> un-check Use continuous scale