topic Re: Bar Chart Sorting Order Month/Year (MM/YY) in QlikView

Bar Chart Sorting Order Month/Year (MM/YY)

waqasshah — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am developing a dashboard unfortunately I am unable to sort out the bars in a chart. I want them in chronological order. like Oct/16 , Nov /16, Dec 17. The values used for calculations are CompleteMonthNamesRefRcvd and CompleteYearNameRcvd.

I have attached the screen shots please review them.

Kind Regards

Waqas Shah

Re: Bar Chart Sorting Order Month/Year (MM/YY)

techvarun — Wed, 11 Oct 2017 09:33:31 GMT

Share a sample to get faster responses

Re: Bar Chart Sorting Order Month/Year (MM/YY)

Chanty4u — Wed, 11 Oct 2017 09:33:38 GMT

try this

in sort tab...

Expression:

=Match(FieldName,' A','b','c') lik so on

or u wan load order ascending or desc chk that

Re: Bar Chart Sorting Order Month/Year (MM/YY)

waqasshah — Wed, 11 Oct 2017 09:37:28 GMT

I have attached screen shots..

Re: Bar Chart Sorting Order Month/Year (MM/YY)

tresB — Wed, 11 Oct 2017 09:42:38 GMT

May be sort by expression:

=Date#(YourDateField, 'MMM/YY')

However, ideally this should be taken care in the script itself. You should create the field as a dual, like:

Dual(Left(....)&'/'&Right() , Date#(YourDateField, 'MMM/YY')) as YourDate

Once this is done in the script, the dates would be be automatically sorted in the UI.

Re: Bar Chart Sorting Order Month/Year (MM/YY)

its_anandrjs — Wed, 11 Oct 2017 09:48:54 GMT

Share some sample file make be your date is not in proper format like MMM/YY or MMM YY or MMM /YY

In Sort Tabe use

=Alt(

date#( CompleteMonthNamesRefRcvd &'/'& CompleteYearNameRcvd, 'MMM/YY' ),

date#( CompleteMonthNamesRefRcvd &' /'& CompleteYearNameRcvd, 'MMM/ YY' ),

date#( CompleteMonthNamesRefRcvd &' '& CompleteYearNameRcvd, 'MMM YY' ) )

Re: Bar Chart Sorting Order Month/Year (MM/YY)

Anil_Babu_Samineni — Wed, 11 Oct 2017 09:55:25 GMT

What if you are getting when you un-select all options from SORT tab?

Re: Bar Chart Sorting Order Month/Year (MM/YY)

waqasshah — Wed, 11 Oct 2017 10:10:40 GMT

Thanks @tresesco

this function works

but I am trying to create the following in my dimension but it wont work..

=Dual(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)) , Date#(CompleteYearNamesRefRcvd, 'MMM/YY')) . please help

Re: Bar Chart Sorting Order Month/Year (MM/YY)

waqasshah — Wed, 11 Oct 2017 10:11:03 GMT

it wont work

Re: Bar Chart Sorting Order Month/Year (MM/YY)

waqasshah — Wed, 11 Oct 2017 10:11:22 GMT

Thanks but it did not work

Re: Bar Chart Sorting Order Month/Year (MM/YY)

tresB — Wed, 11 Oct 2017 10:12:55 GMT

Try like:

Dual(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)) ,

Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)), 'MMM/YY'))

Re: Bar Chart Sorting Order Month/Year (MM/YY)

Chanty4u — Wed, 11 Oct 2017 10:13:42 GMT

Have a look here it may help

Sort date in Month Year format

Sort order with year-month

Re: Bar Chart Sorting Order Month/Year (MM/YY)

its_anandrjs — Wed, 11 Oct 2017 10:14:54 GMT

Try with this

Load

Date(Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&RIGHT(CompleteYearNamesRefRcvd,2),'MMM/YY')'MMM/YY') as FielName

From Source;

In sort use

=Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(CompleteYearNamesRefRcvd,2),'MMM/YY')