topic Re: Sort issue in bar chart in QlikView

Sort issue in bar chart

Tue, 12 Jan 2016 14:36:31 GMT

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!

swuehl — Tue, 12 Jan 2016 14:39:43 GMT

Try sorting by expression

=Max(Date)

ascending.

Anonymous — Tue, 12 Jan 2016 14:41:49 GMT

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.

hemhund2016 — Tue, 12 Jan 2016 14:43:30 GMT

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

Year(Date)&Week(Date)

MK_QSL — Tue, 12 Jan 2016 14:47:16 GMT

Like this?

Gabriel — Tue, 12 Jan 2016 14:47:43 GMT

Hi,

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

Tue, 12 Jan 2016 14:52:30 GMT

Thank you very much ! It worked.