topic Re: Interactive sort on hyperlinked column in QlikView

Interactive sort on hyperlinked column

Anonymous — Mon, 05 Feb 2018 09:16:33 GMT

Hi Everybody,

I would like to know how can we do a interactive sorting or simple sorting on a hyperlinked column in a straight chart. is it even possible?

Thanks in advance

Regards,

Sonthu

Re: Interactive sort on hyperlinked column

Peter_Cammaert — Mon, 05 Feb 2018 10:10:54 GMT

IMHO double-clicking the column header of the expression with the hyperlinks will sort the displayed values. On condition that "Allow Interactive Sort" is enabled in Properties->Sort (check box at the bottom)

Re: Interactive sort on hyperlinked column

Anonymous — Mon, 05 Feb 2018 10:30:38 GMT

Thanks for the reply Peter,

I have tried and it does not work. when i remove the hyperlink, it works but not with Hyperlinks.

Re: Interactive sort on hyperlinked column

Peter_Cammaert — Mon, 05 Feb 2018 10:33:31 GMT

It works for me.

Can you post an example document that shows this behavior? You can scramble all confidential data if you don't want to create a custom example.

Re: Interactive sort on hyperlinked column

Anonymous — Mon, 05 Feb 2018 11:46:49 GMT

hi Peter, If you do not have any problem, can you share your example QVW? it will be bit uncomfortable for me to share the QVW.

Re: Interactive sort on hyperlinked column

Peter_Cammaert — Mon, 05 Feb 2018 12:18:29 GMT

Download the "URL Example.qvw" from discussion Hyperlink in Dimension or in Expression - neither works perfectly

Convert the table at the bottom into a straight table and double-click the "Web Address" expression column.

Re: Interactive sort on hyperlinked column

Anonymous — Mon, 05 Feb 2018 12:51:36 GMT

Hi Peter,

My hyperlinked column is a Number , Sorry if i have not mentioned before. i have tried the Web address and its working but the column sum(value) is not working the way expected.

Re: Interactive sort on hyperlinked column

Peter_Cammaert — Mon, 05 Feb 2018 17:13:55 GMT

The default (interactive) sort method will probably not be what you want.

Did you try sorting by expression, and entering the Sum(value) expression in the sort field?

Re: Interactive sort on hyperlinked column

Anonymous — Tue, 06 Feb 2018 08:30:01 GMT

i have thought about sorting by expression earlier but it is not editable in the chart for the measure sum(value) or for the measure in my chart

Re: Interactive sort on hyperlinked column

Peter_Cammaert — Tue, 06 Feb 2018 08:35:16 GMT

But it seems that the default interactive sort does sort on the Sum() values, either in descending or ascending order.

What sort order do you actually want?

Re: Interactive sort on hyperlinked column

Anonymous — Tue, 06 Feb 2018 08:41:29 GMT

Can you share the QVW you have worked on, let me see what am i doing wrong?

Re: Interactive sort on hyperlinked column

Peter_Cammaert — Tue, 06 Feb 2018 08:46:45 GMT

Sorry, threw it away.

Again, download the document from the link supplied in a previous post. Change the lower pivot into a straight table and in the expresison for column Web Address, change "City" into "Sum(value)". Test the interactive sort by double-clicking the "Web Address" header.

Re: Interactive sort on hyperlinked column

Anonymous — Tue, 06 Feb 2018 08:58:37 GMT

i have implemented the changes as you have mentioned before but after double clicking it is not working the way i expect it too

Can you please take a look in the attached document

Re: Interactive sort on hyperlinked column

Peter_Cammaert — Tue, 06 Feb 2018 10:15:25 GMT

It works for me. Double-clicking the "Web Address" column sorts the data in one of two ways.

Remember that by using the ampersand operator ( & ) in an expression, QlikView implicitly converts the result to a string value. If you do not enable the Text Sort option in the Sort tab, you won't get the same behaviour. I guess that is the reason why you think your second column doesn't sort.

If you prefer the Numerical Sort method, use the Dual() function to attach a string value to the numerical expression result and enable Numerical Sort. Like:

=Dual(Sum(Value) & '<URL>' & URL, Sum(Value))

Re: Interactive sort on hyperlinked column

Anonymous — Wed, 07 Feb 2018 09:35:26 GMT

Thank you peter this is working now.