topic Re: Links in pivot table in QlikView

Links in pivot table

Anonymous — Tue, 16 Jun 2015 14:03:42 GMT

Hi All,

I have a field with Links in it and another field showing number of links in the links field. Both are expressions with some other fields like object name etc, as dimensions. My requirement is to show all these in pivot table and when I tried to show the link field expression as calculated dimension everything went fine except the link is no more a link, instead it's a text. I did so because when there are more than 1 link under one object name, it shows a '-' in that column. In pivot table when the object name is expanded the number of links should be displayed and when it is expanded the links should be displayed. This is the order I require.

Re: Links in pivot table

marcus_sommer — Tue, 16 Jun 2015 14:24:07 GMT

Within a pivot you need to display the link as expression then only there is the possibility to set the interpretation to a link. I think your NULL result will be caused through the fact that there more then one value is available - this meant you need to use an aggregation-function like only/min/max/... to return a valid result: Use Aggregation Functions!

- Marcus

Re: Links in pivot table

Anonymous — Wed, 17 Jun 2015 08:58:22 GMT

Hi Marcus,

Thanks for the quick reply, could you be more specific about how to use those in the expression. I actually have taken the links field from another table and attached it to the current object name and number of links table. When the two tables were separate everything was fine, but now when I merged the two the problem with links exists. I am not able to figure out how to refine the expression and so here I am attaching the one I used to get the links into the current table.

Dimensions: Object_Name

Nb_of_Links

Measures:

Expression : RequestNumber &'<URL>'& Link

Re: Links in pivot table

marcus_sommer — Fri, 19 Jun 2015 04:30:14 GMT

RequestNumber and Link must be definitely unique within the context ob your dimensions Object_Name and Nb_of_Links - if not they will return NULL. To handle this you need an additionally dimension which divided the various values into single values or you need an aggregation-expression for them like:

max(RequestNumber) &'<URL>'& maxstring(Link)

max(RequestNumber) &'<URL>'& subfield(concat(Link, ','), ',', 1)

- Marcus