topic Re: Sorting issue in straight table in QlikView

Sorting issue in straight table

Wed, 04 Sep 2013 10:22:48 GMT

Hello All,

I have 3 dimensions and 2 expressions in my straight table. I want to put the sorting criteria in all my dimensions and expressions. I have enabled sorting in the Sort Tab but in my table it's only sorting by Pocs.QTY.

Can you help me on this?

Thanks,

Viju

Re: Sorting issue in straight table

Gabriel — Wed, 04 Sep 2013 10:38:20 GMT

Hi Viju,

If I understand you, you want to sort your 3 dimension to your preferred choice.

In your Straight Table go to -> Sort tab -> Select the First Dimension -> Check Expression -> Click on the Eclipse (...) and type in Match(DimensionValue,'Date','Date','Date','Date','Date','Date'). You will have to repeat this exercise 3 time for all your Dimensions.

Hope this is helpful

Best Regards,

Gabriel

Re: Sorting issue in straight table

cesaraccardi — Wed, 04 Sep 2013 11:08:36 GMT

Hi,

Please have a look at the Sort Tab and make sure all the fields have a single sorting criteria selected. Also it would be good to check the Group dimension PeriodDate.Date to see if you have defined sorting criteria for the fields too.

Kind Regards,

Cesar

Re: Sorting issue in straight table

Mon, 09 Sep 2013 12:30:59 GMT

Hi All,

Thanks for your answers but I can't find the solution.

I have attached a qvw in which I have my table. My problem is that I want to sort all the columns in the straight table, that is, to have the small sorting arrow in all the columns.

Can you please check if this is possible?

Thanks.

Viju

Re: Sorting issue in straight table

Clever_Anjos — Mon, 09 Sep 2013 12:35:48 GMT

I can´t see your app, only the picture

Re: Sorting issue in straight table

Brice-SACCUCCI — Mon, 09 Sep 2013 12:37:44 GMT

Hi,

you cannot split a line of data. What result do you expect by sorting all the columns?

If you have this data:

1; 2; 3

2; 3; 1

3; 1; 2

Sorting by column 1 gives:

1; 2; 3

2; 3; 1

3; 1; 2

Sorting by column 2 gives:

3; 1; 2

1; 2; 3

2; 3; 1

Sorting by column 3 gives

2; 3; 1

3; 1; 2

1; 2; 3

You could say : "Sort by column 1, then by column 2" which means "Sort by column 1. If several lines have the same value for column 1, then sort them using column 2".

Regards,

Brice

Re: Sorting issue in straight table

er_mohit — Mon, 09 Sep 2013 12:38:13 GMT

if you want to sorting any field in straight table either dimension side or expression side

then just double click on label field of that particular column

hope it helps