Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

get sorting of table object

Hello,

is there a way to read the sorting of a table object? What I want to do is using it in the title of the table...

regards,

TA

8 Replies
Not applicable
Author

can you explain clearly please?

Not applicable
Author

Not sure if I understand you correctly.

If you want to check the sorting in table bx, you can right click on the table box, go to Properties-Sort tab.

Also, if you want to have a title on table box, then after Properties in General tab, you can specify the title.

Table_Box.bmp

Hope this helps!

Not applicable
Author

Hi ,

Declare a variable like

SET vSort="FieldName ";

then in the table box properties under the sort tab there in the expression use this variable in that.

and use same variable in the TableBox caption (Header ) .

please let me know if there is anything.

Regards

Yusuf

Anonymous
Not applicable
Author

Do you want to set the table name depending upon which column a user has selected to sort by?

Not applicable
Author

We want to allow "Interactive Sort" in straight tables and want to show the name of the first column according to sort priority in the titel

e.g. "sales 2013 sorted by customer" (or "sorted by sales")

and if possible "sales 2013 sorted by customer descending"

I hope you understand now what I mean.

regards,

TA

Not applicable
Author

exactly

Not applicable
Author

one idea would be to use a macro, like the one given in this link.

Sort via Macro question

then use a variable to store the dimension used to sort the chart and display it in a textbox or something.

Not applicable
Author

Hi ,

You can also design the extension object with the similar structure of tableBox .

There you can use macro and so on .

Regards

Yusuf