Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting issue in Straight table

HI all,

Can any one help me with the sorting issue in straight table, when there are common names under a dimension.

I've the data as below

CountryDepartmentSALES
USAETS200
USABFSI0
UKETS1000
UKBFSI23
IndiaETS63
JapanETS250
JapanBFSI89
South AfricaETS91

and I would like to sort the countries based on the sales

and I would like to the see the output as below.

CountryDepartmentSALES
UKETS1000
JapanETS250
USAETS200
South AfricaETS91
JapanBFSI89
IndiaETS63
UKBFSI23
USABFSI0

Currently sorting the dimension based on the numeric value doesn't give the desired output as there are common names under country.

Pls help me with this.




Thanks,

Surendra

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Create a straight table and go to sort tab

View solution in original post

1 Reply
MK_QSL
MVP
MVP

Create a straight table and go to sort tab

View solution in original post