topic Re: sorting not working on concatinating numeric value in QlikView

sorting not working on concatinating numeric value

Mon, 19 May 2014 12:06:47 GMT

Hi,

I have a total field with values ranges from 1 to 100.

It displays fine in ascending order in listbox but when I try to concat the values in a variable, sorting is not working.

Example, I have values like

100

when im concatinating these values using concat(distinct total,'/')

im Getting the follwing

0 / 1 /100 / 2 /23 /25 /42 / 65

but I want

0 / 1 / 2 /4 /23 /25 /42/65/100

Am I missing Something?

Re: sorting not working on concatinating numeric value

anbu1984 — Mon, 19 May 2014 12:21:56 GMT

Try this

concat( No,'/',No)

Re: sorting not working on concatinating numeric value

senpradip007 — Mon, 19 May 2014 12:41:58 GMT

If you want to it in script try like this

LOAD * Inline [
AA
0
1
2
4
23
25
42
65
100
];

B:
NoConcatenate
LOAD
AA,
If(RowNo()=1, AA, Peek('BB',-1)&'/'&AA) AS BB
Resident A;

DROP Table A;

Re: sorting not working on concatinating numeric value

Mon, 19 May 2014 12:50:36 GMT

Hi Anbu,

Thank You so much...

Its Working Great!!!!

I want to know like what the third parameter actually does?

Re: Re: sorting not working on concatinating numeric value

anbu1984 — Mon, 19 May 2014 12:54:59 GMT

Third parameter is sort-weight.

From QV help

concat ([ distinct ] expression [, delimiter [, sort-weight]])

Returns the aggregated string concatenation of all values of expression iterated over a number of records as defined by a group by clause. Each value may be separated by the string found in delimiter. The order of concatenation may be determined by sort-weight. Sort-weight should return a numeric value where the lowest value will render the item to be sorted first. If the word distinct occurs before the expression, all duplicates will be disregarded.

Re: sorting not working on concatinating numeric value

Mon, 19 May 2014 13:04:05 GMT

Thanks again!

Sent from Samsung Mobile