Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

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
Partner - Master II
Partner - Master II

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

View solution in original post

6 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
alexandros17
Partner - Champion III
Partner - Champion III

Try in the label of the column:

for example:

'Descr. Year: ' & $(vAnoActual)

let me know

spividori
Specialist
Specialist
Author

Thanks for answering.

Attached example.

Regards.

ogster1974
Partner - Master II
Partner - Master II

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
Specialist
Specialist
Author

Ok, thank you very much Andy.

Regards.

vadimtsushko
Partner - Creator III
Partner - Creator III

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