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: 
Not applicable

Sorting_Expression

Hi,

I have to sort my table on the basis of the expressions. And after sorting i have to show only the top 20 values of the expression along with the Dimensions.

Please helppppp!!!!

14 Replies
Not applicable
Author

Hi Manish,

Please have a llok on the attached file.

Hope it helps.

Regards,

Yaseen

nagaiank
Specialist III
Specialist III

You can specify this in the Dimension Limits tab of the chart properties.

A sample application is attached.

Not applicable
Author

Hey in this application there is no sorting at all on the basis of expression

Not applicable
Author

Soring.bmp

I used below expression

 

IF(Domain ='Sales',1,
IF(Domain ='COGS',2,
IF(Domain ='Marketing',3,
IF(Domain

='Amortization',4,5)))

Not applicable
Author

hey in your report Top 5 expresisons are sorted as 400,200,300,800,500.But i want that they should be sorted as 800,500,400,300,200.

Not applicable
Author

Then uncheck expression from Sorting.

Use Dimension limits.

Soring1.bmp

For all dimensions dont ckeck any option.

Not applicable
Author

here is the attached sample data application. Pleasetell how to sort

Not applicable
Author

Please find attached doc.

Not applicable
Author

here the partial sum which it's showing is of all the rows not of the top 5