topic Re: get sorting of table object in QlikView

get sorting of table object

Tue, 19 Nov 2013 06:43:44 GMT

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,

Re: get sorting of table object

Tue, 19 Nov 2013 07:29:01 GMT

can you explain clearly please?

Re: get sorting of table object

Tue, 19 Nov 2013 08:17:54 GMT

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.

Hope this helps!

Re: get sorting of table object

Tue, 19 Nov 2013 08:19:43 GMT

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

Re: get sorting of table object

Anonymous — Tue, 19 Nov 2013 08:25:23 GMT

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

Re: get sorting of table object

Tue, 19 Nov 2013 08:33:37 GMT

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,

Re: get sorting of table object

Tue, 19 Nov 2013 08:35:25 GMT

exactly

Re: get sorting of table object

Tue, 19 Nov 2013 09:56:31 GMT

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.

Re: get sorting of table object

Tue, 19 Nov 2013 10:04:51 GMT

Hi ,

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

There you can use macro and so on .

Regards

Yusuf