Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rafael5958
Creator
Creator

sort table

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??

1 Solution

Accepted Solutions
maxgro
MVP
MVP

add a straight table chart with

dimension     [Column A]

expression     sum([Column B])

and double click on the label of Column B to sort

View solution in original post

4 Replies
fernando_tonial
Partner - Specialist
Partner - Specialist

Hi Rafael, try this.

LOAD

ColumnA,

Sum(ColumnB) As ColumnB

From Table

Group By ColumnA;

Don't worry, be Qlik.

Tonial.

Don't Worry, be Qlik.
maxgro
MVP
MVP

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
Creator III
Creator III

you should Quick Sort in straight table.

Not applicable

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