topic Re: sort table in QlikView

sort table

rafael5958 — Wed, 22 Jul 2015 17:11:34 GMT

Hi, I have a table like:

Column A Column B

A 10

B 5

A 10

B 1

B 2

B 3

B 1

C 50

I want sort it in real time, like:

Column A Column B

C 50

A 20

B 12

Is there a way to do it with simple tables??

fernando_tonial — Wed, 22 Jul 2015 17:15:00 GMT

Hi Rafael, try this.

LOAD
ColumnA,
Sum(ColumnB) As ColumnB
From Table
Group By ColumnA;

Don't worry, be Qlik.

Tonial.

maxgro — Wed, 22 Jul 2015 17:22:36 GMT

add a straight table chart with

dimension [Column A]

expression sum([Column B])

and double click on the label of Column B to sort

jafari_ervin — Thu, 23 Jul 2015 06:44:39 GMT

you should Quick Sort in straight table.

Thu, 23 Jul 2015 06:49:43 GMT

Hi Rafael, LOAD ColumnA, Sum(ColumnB) As ColumnB From Table Group By ColumnA; OR you can use staight table to use quick sort feature.