Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rafael5958
New Contributor III

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

Re: sort table

add a straight table chart with

dimension     [Column A]

expression     sum([Column B])

and double click on the label of Column B to sort

4 Replies
fernando_tonial
Valued Contributor

Re: sort table

Hi Rafael, try this.

LOAD

ColumnA,

Sum(ColumnB) As ColumnB

From Table

Group By ColumnA;

Don't worry, be Qlik.

Tonial.

MVP
MVP

Re: sort table

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
Contributor II

Re: sort table

you should Quick Sort in straight table.

Not applicable

Re: sort table

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

Community Browser