Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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!!!!

Tags (1)
14 Replies
Not applicable

Re: Sorting_Expression

Hi Manish,

Please have a llok on the attached file.

Hope it helps.

Regards,

Yaseen

nagaiank
Valued Contributor III

Re: Sorting_Expression

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

A sample application is attached.

Not applicable

Re: Sorting_Expression

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

Not applicable

Re: Sorting_Expression

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

Re: Sorting_Expression

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

Re: Sorting_Expression

Then uncheck expression from Sorting.

Use Dimension limits.

Soring1.bmp

For all dimensions dont ckeck any option.

Not applicable

Re: Sorting_Expression

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

Not applicable

Re: Sorting_Expression

Please find attached doc.

Not applicable

Re: Sorting_Expression

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