topic Re: Sort value in a chart and put "Other" at the end in QlikView

Sort value in a chart and put "Other" at the end

Tue, 05 May 2015 09:16:46 GMT

Hi,

I've a chart with several value in dimension, takes for instance :

Dimension	Value
A	1
Other	1
C	1
D	1
B	1

I would like to sorting values in order to have :

Dimension	Value
A	1
B	1
C	1
D	1
Other	1

Infact, I would like to put "Other" at the end. I can't manage the script, so I have to find a solution into properties of chart.

I can't use the alphabetical order, I believe I have to choose the expression order but I have no idea about which function I can use.

Does anyone has an idea ?

Thanks,

Regards,

Marine Le Trionnaire

Re: Sort value in a chart and put "Other" at the end

sasikanth — Tue, 05 May 2015 09:22:03 GMT

Try match function in sort tab-->Expression

Match(Dimension,'A','B','C','D','Other')

Re: Sort value in a chart and put "Other" at the end

patroser — Tue, 05 May 2015 09:22:41 GMT

Is "Other" a real value of this dimension or just the cumulation of all values but the first 4?

Re: Sort value in a chart and put "Other" at the end

robert_mika — Tue, 05 May 2015 09:23:21 GMT

Try:

WildMatch(Dimension,'A','B','C','D','Other')

Can you share your app if this method do not work?

Re: Sort value in a chart and put "Other" at the end

mato32188 — Tue, 05 May 2015 09:28:12 GMT

Hi,

try to

sort your dim asc by expression if(Ord(Dimension)<91, Ord(Dimension), 100).

Re: Sort value in a chart and put "Other" at the end

sunilkumarqv — Tue, 05 May 2015 09:36:00 GMT

HI,

For best you can recreate your Dimension in script

Try like this

If(Field='A',dual('A',1),

Field='B',dual('B',2),Field='C',dual('C',3),Field='D',dual('D',4),Field='Other',dual('Other',5))

Re: Sort value in a chart and put "Other" at the end

nagarjuna_kotha — Tue, 05 May 2015 09:39:02 GMT

Hi,

No need any expression To ur requirement.Simply Go to properties>>Sort>>Enable Text as A-Z.

This is enough for to solve this

Let me know getting solve or not ?

Regards,

Nagarjuna

Re: Sort value in a chart and put "Other" at the end

nagarjuna_kotha — Tue, 05 May 2015 09:42:46 GMT

Hi,

Kindly find below attached file.

Re: Sort value in a chart and put "Other" at the end

patroser — Tue, 05 May 2015 09:48:01 GMT

I guess you neither want to hard code all possible values in your sort expression, nor will "Other" be your last alphabetical value.

Therefore I tried to build a generic expression for sorting:

I tried this one for the following Inline Table:

if(Dim <> 'Other', Ord(Dim), max(TOTAL Ord(Dim) + 1))

where Dim is your actual Field name for the dimension. Just put this expression in the sort expression field and decide wehter to sort it ascending or descending.

Table:

LOAD * INLINE [

Dim, Val

A, 1

Other, 1

Z, 1

C, 1

D, 1

B, 1

];

Patrick

Re: Sort value in a chart and put "Other" at the end

Tue, 05 May 2015 09:49:11 GMT

Thanks for your answer.

It seems to be right but I would like to be sure I've really understand how to use this function :

I put it : Match(Dimension,'Other') because the others values could be differents. Sometimes A,B,C, or sometimes M,X... so I can't put A,B,C,D... in this function.

Does this function sorted only values which are mentionned ? For the other values I can add an alphabetical order.

Is it right ?

Thanks,

Marine Le Trionnaire

Re: Sort value in a chart and put "Other" at the end

Tue, 05 May 2015 09:56:27 GMT

Hi,

Thanks for your answer.

I tried this expression and it's OK, that was the expression I would like to create.

Thanks,

Regards,

Marine Le Trionnaire

Re: Sort value in a chart and put "Other" at the end

Tue, 05 May 2015 10:03:14 GMT

Thanks for your answer.

I tried it, it seems to be OK. Like the match function I put WildMatch(Dimension,'Other') and I add an alphabetical order and it's OK.

Regards,

Marine Le Trionnaire