Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: get sorting of table object

can you explain clearly please?

Not applicable

Re: get sorting of table object

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

Re: get sorting of table object

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

Employee
Employee

Re: get sorting of table object

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

Not applicable

Re: get sorting of table object

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

Re: get sorting of table object

exactly

Not applicable

Re: get sorting of table object

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

Re: get sorting of table object

Hi ,

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

There you can use macro and so on .

Regards

Yusuf

Community Browser