Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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!

Tags (3)
1 Solution

Accepted Solutions
Highlighted

Re: Sort issue in bar chart

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
Highlighted
MVP
MVP

Re: Sort issue in bar chart

Try sorting by expression

=Max(Date)

ascending.

Highlighted

Re: Sort issue in bar chart

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
Contributor

Re: Sort issue in bar chart

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

Year(Date)&Week(Date)

Highlighted
MVP
MVP

Re: Sort issue in bar chart

Like this?

Highlighted
Partner
Partner

Re: Sort issue in bar chart

Hi,

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

Highlighted
Not applicable

Re: Sort issue in bar chart

Thank you very much ! It worked.