Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

4 Replies
chauhans85
Esteemed Contributor

Re: arrange date in bar chart

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

else if you have datefield  then write down in sort express

hope this helps

MVP
MVP

Re: arrange date in bar chart

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]

Re: arrange date in bar chart

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.

OR

use below

=Year * 100 + Month

By this you will always have numbers that are 6 digits

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

OR

try with sort by this expression (in sort tab)

=Year & num(Month, '00')

Regards

ASHFAQ

Not applicable

Re: arrange date in bar chart

Hi

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

Community Browser