Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting issue in straight table

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

6 Replies
Gabriel
Partner
Partner

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

cesaraccardi
Specialist
Specialist

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

Not applicable
Author

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

Clever_Anjos
Employee
Employee

I can´t see your app, only the picture

baa
Employee
Employee

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

er_mohit
Master II
Master II

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