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 in straight table using set analysis

hi

i have a straight table having diiferent columns. one of them is employeeid and in it values are from 1-9 in random order and repeating itself.

how can i sort it in ascending order and show distinct values using set analysis or is there any other way to do that??/

i am attaching a screenshot with it for better understanding

2 Replies
v_iyyappan
Specialist
Specialist

Hi,

     I attached a sample QV file. Hope its helpful for you.

Regards,

Iyyappan

Not applicable
Author

For sorting the column,we have two ways

1.just right click on straight table it will show the option sort click on this it will sort ur column.

2.Go to the chart properties here you will found the option sort, give the priority cloumn which you want.Means if you want to set Employee ID wise sorting you have to put it top of the stack using promote button.

i am sending a attachment hope it will give you more clarity