Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jgreen95
Contributor III
Contributor III

1

 
Labels (2)
1 Solution

Accepted Solutions
Aditya_Chitale
Contributor III
Contributor III

Hi,

Under the sorting tab, select 'sort by expression' option and pass your % expression in it

Regards,

Aditya Chitale

View solution in original post

4 Replies
martinpohl
Partner
Partner

create an inline table:

Sort_order:

load

dual(Text,Sort) as Region;

load * inline [

Text,Sort

East,1

West,2

South,3

North,4

];

So your Region field is dual, text to show, sort number to sort by.

It's like a month, jan = 1, feb = 2 and so on...

Regards

jgreen95
Contributor III
Contributor III
Author

I need to be able to sort by the Pass % not by the number associated to the region

Aditya_Chitale
Contributor III
Contributor III

Hi,

Under the sorting tab, select 'sort by expression' option and pass your % expression in it

Regards,

Aditya Chitale

View solution in original post

martinpohl
Partner
Partner

maybe something like

avg(total <Region> [Pass%])

as I unterstand that there are many values for Region / Subregion