topic Bar chart date format in QlikView

Bar chart date format

Tue, 20 Jun 2017 15:26:02 GMT

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.

Re: Bar chart date format

Anil_Babu_Samineni — Tue, 20 Jun 2017 16:11:32 GMT

Create Island table and use that field into Dimension

Re: Bar chart date format

Tue, 20 Jun 2017 16:50:27 GMT

such as this.. ?

LOAD * INLINE [

Num, Month,

1, Jan

2, Feb

...

12, Dec];

Re: Bar chart date format

passionate — Tue, 20 Jun 2017 17:16:28 GMT

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

Re: Bar chart date format

passionate — Tue, 20 Jun 2017 17:22:17 GMT

Best Practices says to use less Island tables

Re: Bar chart date format

Tue, 20 Jun 2017 19:19:04 GMT

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?

Re: Bar chart date format

Anil_Babu_Samineni — Wed, 21 Jun 2017 01:58:03 GMT

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')

Re: Bar chart date format

santhoo_san — Wed, 21 Jun 2017 06:45:53 GMT

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