Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ogster1974
Honored Contributor II

Is it possible to set the sheet name dynamically in Qlik Sense?

Hi Guys

I'm going through a localisation exercise on our dashboards and have been able to translate most elements of the document into their local equivalent.

I understand Sheet needing to have an ID for reference programmatically but are their plans to make the title and description set by expression in future release or a work around I can use?

Thanks in advance.

1 Solution

Accepted Solutions
ogster1974
Honored Contributor II

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

So if you are building a mash up using Qlik Sense to deliver visualisations into the overall app you can use this approach but out of the box for some reason the Sheet name and certain labels are not able to be set dynamically just as static text.

8 Replies
Not applicable

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

Did you ever make any headway with this? I'm looking for the same thing.

ogster1974
Honored Contributor II

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

Nothing as yet.  the same static labels and sheet names are present in the latest version of sense unfortunately.

reddys310
Honored Contributor II

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

Hi Andy,

Though its not implicitly possible in qliksense, you can acheive this using an extension object for sure. Totally possible.

Thanks,

Sangram.

reddys310
Honored Contributor II

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

Adding in more info:

This is the approach in your extension:

first get the sheet id of the present sheet using the Extesnion API method, Once you have the ID read the hypercube for the title text and then use this code:

if(vSheetId = 'XYZ'){

$("#sheet-title span").text(TextFromHypercube_Sheet1);

}else if(vSheetId = 'ABC'){

$("#sheet-title span").text(TextFromHypercube_Sheet2);

}

Thanks,

Sangram.

ogster1974
Honored Contributor II

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

So if you are building a mash up using Qlik Sense to deliver visualisations into the overall app you can use this approach but out of the box for some reason the Sheet name and certain labels are not able to be set dynamically just as static text.

stascher
Contributor

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

I have a stupid question; in order for the above to work, you have to include an instance of the extension object on each page that you want to change, correct?

-Steve

pauljohansson
Contributor II

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

Hi Andy,

From version Sense November its possible for the sheet names to an expression.

br

Paul

aqu
Contributor II

Re: Is it possible to set the sheet name dynamically in Qlik Sense?

Hi,

In Qlik Sense November 2017 Release You can set Sheet title dynamically;

sheettitle.jpg

Regards

Lucke