Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

robertocesp
Contributor II

How to create a Link expression in Pivot Tables?

Hi,

I am creating a link expression in a pivot table, and it's not working. In the straight table works perfectly, but I will need that the fields are being grouped by family - first, then type, code and sub-code. The link expression will be in the code. For example:

Wood tools >Hand >1223 >1

Wood tools >Hand >1223 >2

Wood tools >Hand >1223 >3

In a straight table you will have one row per record, but in the pivot table you will have only

                                            1

Wood tools >Hand >1223 >2

                                            3

I will like to have the code in a link expression, instead of have it that way I will have something like:

Wood tools >Hand >code >1

                                 total

Wood tools >Hand >code>2

                                 total

Wood tools >Hand >code>3

                                 total

Any idea on how to do it?

3 Replies
stabben23
Honored Contributor

Re: How to create a Link expression in Pivot Tables?

Hi,

use partial sums here

partialsums.GIF

robertocesp
Contributor II

Re: How to create a Link expression in Pivot Tables?

I did it, but this is what I am getting:

robertocesp
Contributor II

Re: How to create a Link expression in Pivot Tables?

I need instead of URL and Total, get the value with the link to access it.