topic Sort value in valuelist() doesn't work in App Development

Sort value in valuelist() doesn't work

Micki — Fri, 29 Jan 2021 11:21:12 GMT

Hi folks i have piechart

in which dim have Valuelist(1,2,3,4) and it's working fine.

What i want is to sort those values inside valuelsit()

Like if var = 1, Valuelist(1,2,3,4), IF var =2, Valuelist(2,1,3,4))

DOES IT POSSIBLE ? CAUSE I GET ERROR INVALID DIMENSION

Re: Sort value in valuelist() doesn't work

marcus_sommer — Fri, 29 Jan 2021 14:33:51 GMT

Valuelist() could be quite tricky. Never tried to sort them because I don't use them else creating such artificial dimension within the script. The handling is much easier - means something like this:

Dim: load recno() as DIM autogerate 4;

- Marcus

Re: Sort value in valuelist() doesn't work

Micki — Fri, 29 Jan 2021 15:30:56 GMT

@marcus_sommer , in my case only valuelist() is ONLY acceptable solution, i did it actually found very simple solution

MATCH($(ValueList),
IF($(vPie_Chart_Sort) = 1, 'Blocked',
....))))))

working like a charm:)