topic Re: Urgent! Qlikview Sorting problem in QlikView

Urgent! Qlikview Sorting (Order by) problem

kcchoi0626 — Mon, 03 Apr 2023 01:24:35 GMT

I search many post about sorting, but i cannot find an solution.

my database only have 4 rows,

Sally is the last input.

I could like to build an cumlative sales Curve with each person sales amount Bar Chart

However, due to sorting problem Sally always be the last row whatever I do sorting or not.
I use resident load already, not sure why order by is not working. Anyone can help ?

Or any other alternative for my set analysis??

Re: Urgent! Qlikview Sorting problem

rubenmarin — Sun, 02 Apr 2023 10:42:01 GMT

Hi, values are sorted by load as they are loaded, maybe the name2 field has some values loaded previously, try setting the inline table at the beggining of the script.

Also confirm that the chart sort properties doen't have any other sort checked, it looks like it's sorted by expression value.

Re: Urgent! Qlikview Sorting problem

kcchoi0626 — Mon, 03 Apr 2023 01:02:04 GMT

The dataset actually come from inline table , below is the coding

estGroup:
Load * Inline [

Name2, Age2, Grouping, AMT

Wladimir, 31, IBG3, 100

Wladimir, 31, IBG4, 200

Wladimir, 31, IBG3, 300

Wladimir, 31, IBG3, 400

Sue, 22, IBG4, 500

Sue, 22, IBG4, 7

Sue, 22, IBG4, 89

Sue, 22, IBG5, 234

Tom, 34, IBG6, 333

Sally, 37, IBG1, 900

];

NoConcatenate
TestGroup2:
Load
Name2,
Sum(AMT) as Total_sales
Resident TestGroup
group by Name2;

NoConcatenate
TestGroup3:
Load
*
Resident TestGroup2
order by Total_sales desc,;

drop table TestGroup,TestGroup2;

and for the chart is sorted by Y-value

Re: Urgent! Qlikview Sorting problem

kcchoi0626 — Mon, 03 Apr 2023 01:10:51 GMT

I found that I even cannot sort by field Name2, the table just cannot change ordering

Re: Urgent! Qlikview Sorting problem

MayilVahanan — Mon, 03 Apr 2023 02:53:09 GMT

Might be, in the sort tab, for Field Name 2, no sorting is specified [like expression, frequency, numeric value, text], in that case only, you can't able to sort by "Field name2".

Either, you can mention Expression [Asc / desc] by Sum(Total_Sales), it will work as expected.
And also, check the "interactive sort" option.

Re: Urgent! Qlikview Sorting problem

rubenmarin — Mon, 03 Apr 2023 06:11:27 GMT

Hi, if the option to sort by Y-Value is checked all the others are disabled, uncheck this option to select another sorting option.