sort table

[rafael5958]

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]

Hi Rafael, try this.

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

Don't worry, be Qlik.

Tonial.

[maxgro · Accepted solution]

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]

you should Quick Sort in straight table.

[#5]

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