topic Re: Sorting_Expression in QlikView

Sorting_Expression

Mon, 04 Mar 2013 06:07:43 GMT

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

Re: Sorting_Expression

Mon, 04 Mar 2013 06:15:14 GMT

Hi Manish,

Please have a llok on the attached file.

Hope it helps.

Regards,

Yaseen

Re: Sorting_Expression

nagaiank — Mon, 04 Mar 2013 06:23:49 GMT

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

A sample application is attached.

Re: Sorting_Expression

Mon, 04 Mar 2013 06:26:17 GMT

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

Re: Sorting_Expression

Mon, 04 Mar 2013 06:31:19 GMT

I used below expression

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

='Amortization',4,5)))

Re: Sorting_Expression

Mon, 04 Mar 2013 06:37:06 GMT

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.

Re: Sorting_Expression

Mon, 04 Mar 2013 06:44:19 GMT

Then uncheck expression from Sorting.

Use Dimension limits.

For all dimensions dont ckeck any option.

Re: Sorting_Expression

Mon, 04 Mar 2013 07:08:25 GMT

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

Re: Sorting_Expression

Mon, 04 Mar 2013 07:15:04 GMT

Please find attached doc.

Re: Sorting_Expression

Mon, 04 Mar 2013 07:27:44 GMT

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

Re: Sorting_Expression

Mon, 04 Mar 2013 07:34:45 GMT

Actually im not getting what you are looking for.

I have shown only top5 sales based on the expression SUM(SALES).Accordingly all the dimensions are showing.

This is the straight table and it has no partial sums.

Re: Sorting_Expression

karthickv — Mon, 04 Mar 2013 07:36:32 GMT

Hi Manish ,

Please do the below changes to your application . Hope this helps.

Regards,

karthick V

Re: Sorting_Expression

Mon, 04 Mar 2013 07:44:10 GMT

Hi Karthi,

I did the same changes in his application.

I am not sure what exactly he is looking.

Re: Sorting_Expression

Mon, 04 Mar 2013 08:13:28 GMT

hey all problem is solved thnx all for the help

Re: Sorting_Expression

Mon, 04 Mar 2013 08:35:38 GMT

Have you used the above code or something else ?