topic Re: how to sort a cyclic group in QlikView

how to sort a cyclic group

rudywelvaert — Wed, 03 Jan 2018 10:03:54 GMT

Hi,

A pivot tabel is based on a table with the fields:

Region (Text)

Month (Integer)

Year (Integer)

Amount (Integer)

The dimensions are:

The cyclic group Year_Month consist of two fields:

Year with label Year

=Num(Month, '00') & '/' & Num(Year, '0000') with label Month

The expression is:

=Sum(Amount)

The dimension Year_Month is pivoted

I get this result:

The dimension Year_Month is not sorted: 01/2018, 12/2017, 07/2017, 11/2017, ....

I want this result:

The dimension Year_Month should be sorted per year and in the same year per month:
01/2016, 02/2016, 03/2016, .... 12/2017, 01/2018

How can this be done?

In attachment my example Cyclic_Group_Order.qvw

Thanks

R.W.

mdmukramali — Wed, 03 Jan 2018 10:08:26 GMT

Hi,

You have to apply the sorting in Group Settings.

Edit the Group Like below.

PFA.

tresB — Wed, 03 Jan 2018 10:12:35 GMT

Like this?

rudywelvaert — Wed, 03 Jan 2018 10:26:39 GMT

Thanks Mohammed,

This works perfectly.

The sort expression can be simplified to:

=Year * 100 + Month