Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort issue in bar chart

Hi,

I have an issue in a bar chart where as Dimension I have : week(Date) and 3 expressions

Opened Cases : count(Distinct if(DateType='Open', CaseNumber))

Closed Cases : count(Distinct {$<DateType={'Closed'}>}  CaseNumber)

Remaining : count(Distinct if(DateType='Open', CaseNumber)) - count(Distinct {$<DateType={'Closed'}>}  CaseNumber)  (!Here I use Full Accumulation)

And in the sort tab I have :

Sorting by Week : State = 'Ascending' and Numeric Value = 'Ascending'

The selection I make is in a RangeDate by DateType='Open', from 01/09/2015 to 12/01/2016.

My goal is to have Week1 and Week2 at the end, because Week1 and Week2 are from January 2016, after 2015.

(Check the attached file)

Can you give me any idea how can I resolve this ? Or any work arounds ?

If you need any information, tell me.

Thank you!

1 Solution

Accepted Solutions
bill_markham

How about creating a composite field of Year & Week to have values like :

     2015|52

     2016|01

Then if you sort against this you data should end up in the order your require.

View solution in original post

6 Replies
swuehl
MVP
MVP

Try sorting by expression

=Max(Date)

ascending.

bill_markham

How about creating a composite field of Year & Week to have values like :

     2015|52

     2016|01

Then if you sort against this you data should end up in the order your require.

View solution in original post

hemhund2016
Creator
Creator

You could sort the Week as expression in ascending order using below.

Year(Date)&Week(Date)

MK_QSL
MVP
MVP

Like this?

Gabriel
Partner
Partner

Hi,

In your Sort tab, use Expression and have Year in the expression and sort ASC

Not applicable
Author

Thank you very much ! It worked.