topic Re: Dimension/SortOrder getting displayed in Current selection in QlikView

Dimension/SortOrder getting displayed in Current selection

Wed, 30 Jan 2013 15:45:12 GMT

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.

Re: Dimension/SortOrder getting displayed in Current selection

Wed, 30 Jan 2013 20:25:35 GMT

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

Re: Dimension/SortOrder getting displayed in Current selection

Gabriel — Wed, 30 Jan 2013 21:50:16 GMT

Hi,

I will use ~ after the filed name in the script

Regards,

Gabriel

Re: Dimension/SortOrder getting displayed in Current selection

Wed, 30 Jan 2013 23:53:20 GMT

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.

Re: Dimension/SortOrder getting displayed in Current selection

Wed, 30 Jan 2013 23:54:47 GMT

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.

Re: Dimension/SortOrder getting displayed in Current selection

Thu, 31 Jan 2013 08:36:18 GMT

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

Re: Dimension/SortOrder getting displayed in Current selection

Gabriel — Fri, 01 Feb 2013 23:15:09 GMT

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