topic Re: How to create link for each dimension value in straight table in QlikView

How to create link for each dimension value in straight table

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In the attached image I have to create link for each dimension value in straight table. When I click on a link it will open a separate sheet with details for customer. Can it be possible here? as it is possible in Cognos.

Thanks,

Sandip

Re: How to create link for each dimension value in straight table

Anonymous — Sat, 31 Dec 2016 16:54:49 GMT

Instead of linking to another sheet you could do a conditional Show / Hide via the Layout tab of your table's properties with a condition like :

GetSelectedCount(Firm) <> 1

And this should hide the table when a single Firm is selected.

Then create your Customer Details object ~~on the same tab with a conditional Show / Hide like :~~

GetSelectedCount(Firm) = 1

This should show those object ~~when a single Firm is selected.~~

Re: How to create link for each dimension value in straight table

HirisH_V7 — Mon, 02 Jan 2017 05:03:59 GMT

Hi,

Check this Example May be its helpful for u,

Using Field event triggers,

Else, we can do another way by placing transparent text objects on every dimensional fields .once clicking on them will direct to corresponding sheets.

HTH,

PFA,

Hirish