Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

spividori
Valued Contributor

Pivot table column title

Hi.

I assign two variables in the script

vAnoActual = 2015

vAnoAnterior = 2014

Then I show the sale in a pivot table corresponding to those years in separate columns. Can be displayed in the title of the columns the value of these variables?

Regards.

Sandro.

1 Solution

Accepted Solutions
ogster1974
Honored Contributor II

Re: Pivot table column title

I see what you want to do Sandro. 

Qlik Sense doesn't support dynamic creation of labels for dimensions and measures at present so you will have to use something generic in the column header and then use Title, Subtitle or footnote to add some dynamic context.

I hope they do include this feature for nothing else than to support translated text labels.

Regards

Andy

6 Replies
MVP
MVP

Re: Pivot table column title

Yes it can.

If you want help doing it, I suggest you post a sample qvw with data and the object(s) for the headers.

Re: Pivot table column title

Try in the label of the column:

for example:

'Descr. Year: ' & $(vAnoActual)

let me know

spividori
Valued Contributor

Re: Pivot table column title

Thanks for answering.

Attached example.

Regards.

ogster1974
Honored Contributor II

Re: Pivot table column title

I see what you want to do Sandro. 

Qlik Sense doesn't support dynamic creation of labels for dimensions and measures at present so you will have to use something generic in the column header and then use Title, Subtitle or footnote to add some dynamic context.

I hope they do include this feature for nothing else than to support translated text labels.

Regards

Andy

spividori
Valued Contributor

Re: Pivot table column title

Ok, thank you very much Andy.

Regards.

vadimtsushko
Contributor III

Re: Pivot table column title

Take a look at that document with a possible solution Emulating dynamic labels in Qlik Sense

Community Browser