Dimension Shouldn't work in Table, it should be rigid or locked.

[SK28]

Hi,

we have created a KPI table, the data for each kpi is coming from different sources.

So we have concatenated all the Important KPI's into One single table in the back end

to show those metrics as a Heat map table, WHICH SHOULD HAVE A LINK TO EACH SHEET OF THOSE METRICS.

Here is the sample data

 There are around 35 programs & 35 sheets associated to those programs.

We have create a dimension and assigned sheet links to it.

so user comes & clicks the link he should navigate to respective sheet 

for example user click on "Abc" program he will see the detailed Analysis of that Abc program data(Tables charts etc)

The problem here is we have created a config file & linked it with the Program data.

The ask here is 

if the user clicks on it accidentally, it's filtering to that record.

The Click on that dimension Shouldn't work.

It should be a stagnent nothing should work.

For that I have used only function and 

Only({<Required = {'Yes'}>}Program)

as a measure but, I'm unable to link the sheet URL as there is no URL link  option isn't available for measures in Qliksense.

Can anyone please help me on tthis requirement.

Appreciate your help!