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

Dimension/SortOrder getting displayed in Current selection

Hi friends:

I am using a SortOrder field to Sort my dimensions.

I am using a Straight table and using SortOder field as a dimension.

I sort my table on this SortOrder field but hide it by using "Hide column" in the presentation.

This sortOrder does not show up in the table but when a user click on any data item in the chart ,

this field shows up in the current selection along with other items.

How can i hide this so that it does not appear in the current selection.

Thanks.

6 Replies
Not applicable
Author

You can order any field by an expression, without needing to show the field in the table.

JG

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

I will use ~ after the filed name in the script

Regards,

Gabriel

Not applicable
Author

Juan:

Thanks for your response.

I have to sort the dimensions and not sure how i can sort in the expression.

But i was able to clear out sort order from the current selection by using a macro.

Not applicable
Author

Gabriel:

Thanks for your response.

I used ~ after my field in the script but it did not work out.

It still showed sort order field in the current selection.

But i was able to clear out sort order from the current selection by using a macro.

Not applicable
Author

You can use the order by expression, in the Sort tab:

Capture.PNG

JG

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Chad,

I don't know if you have fixed this issue. I just remember that you have to define

Hideprefix

SET Hideprefix ='~';

then

LOAD Sort order AS [~Sort Order];

Then the rest of your script follow

Click ok

If you also want to hide the field completely, go to USER PREFERENCES (alt+ctrl+U) then uncheck Show system field

Click OK

Hope this helps

Regards,

Gabriel