topic Re: Sorting in QlikView

Sorting

upaliwije — Sat, 27 Jun 2015 04:12:10 GMT

Hi Dear

I have following command line in my data load script

DATE(POL_PERIOD_FROM,'MMM-YY') &' - '& DATE(POL_PERIOD_TO,'MMM-YY') AS POLICY_PERIOD,

It is working in order and resulting records are as follows

Sep-13 - Sep-14

Sep-10 - Sep-11

Sep-11 - Sep-12

Sep-14 - Sep-15

I have created a pivot table and want sort above data in ascending order. What sort order I should select to do it . Numeric Value does not give the desired result. Pls help me

Re: Sorting

Gysbert_Wassenaar — Sat, 27 Jun 2015 06:13:48 GMT

If you want to sort it as a number then you should make it a number first. You can use the Dual function to do that:

DUAL( DATE(POL_PERIOD_FROM,'MMM-YY') &' - '& DATE(POL_PERIOD_TO,'MMM-YY'),POL_PERIOD_FROM) AS POLICY_PERIOD

Re: Sorting

ecolomer — Sat, 27 Jun 2015 06:15:49 GMT

You can put an expression on label ordered:

=only({1} match(var, 'Sep-10 - Sep-11', 'Sep-11 - Sep-12', 'Sep-13 - Sep-14', 'Sep-14 - Sep-15') )

and also yu can assign a number each group 'Sep-11 - Sep-12' in ordor to use this number in the ordered set