topic arrange date in bar chart in QlikView

arrange date in bar chart

Tue, 01 Jul 2014 09:50:14 GMT

Hi, how do I arrange the dates properly in bar chart? My current bar chart is as such:

Thanks

SunilChauhan — Tue, 01 Jul 2014 09:53:09 GMT

right(Fieldname,4)&num(left(field,3)) in sort expression

else if you have datefield then write down in sort express

hope this helps

tresB — Tue, 01 Jul 2014 09:56:06 GMT

Create the date field using MonthName() in the script, it will get sorted properly in the front end as expected.

Load

MonthName(DateField) as [Month Name]

ashfaq_haseeb — Tue, 01 Jul 2014 09:56:22 GMT

HI,

I would suggest you to create a new field in your data-model like

MonthName(Date_Field) as MonthName

Then use this field in your chart as dimension, this will be properly sorted.

use below

=Year * 100 + Month

By this you will always have numbers that are 6 digits

ex. 201401, 201402,201303,..... and so on

try with sort by this expression (in sort tab)

=Year & num(Month, '00')

Regards

ASHFAQ

Tue, 01 Jul 2014 09:56:41 GMT

Try like this

in edit calculated dimension write

monthname(date)

Bar chart-->Properties-->Sort Tab-->Select the dimension name--> then select order as orginal

Regards

Nirmal