Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ndeeleysww
Contributor

Write Variable to Label

Hello!

In QlikSense, is it possible to output a variable to a label?

For example, I have a pivot table with the column header label of 'Budget', but its for a particular month, so I'd like to add the month name to the label.

Thank you

Neil

Tags (3)
1 Solution

Accepted Solutions
Employee
Employee

Re: Write Variable to Label

Hello Neil,

It seems (with Qlik Sense) that dynamic labels are NOT possible with the Pivot Table object yet. If a label input box has a fx indicator - that means an expression can be used such as defined in a variable or with a function.

Note that fx is not in the Label box.

Please let us know else we can help.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
9 Replies
Not applicable

Re: Write Variable to Label

Try this on the label..

= 'Count of threats by Department '& monthname(Today())

nagarjuna_kotha
Valued Contributor II

Re: Write Variable to Label

Hi,Yes its posible,

Try like this.

sum({<[Opportunity Won/Lost]={'WON'}, [Opportunity Close Quarter/Year]={"$(vPreviousQ)"}>}[Opportunity Amount] * ExRate_$(vCurrency))/1000000

Regards,

Nagarjuna

nagarjuna_kotha
Valued Contributor II

Re: Write Variable to Label

Hi,

Also u can use like this.

=Only({<No={26}>} [$(=vDataLanguage)])

Regards,

Nagarjuna

ndeeleysww
Contributor

Re: Write Variable to Label

Sorry, that didn't work - it just saw the whole thing as a text string.

Employee
Employee

Re: Write Variable to Label

Hello Neil,

It seems (with Qlik Sense) that dynamic labels are NOT possible with the Pivot Table object yet. If a label input box has a fx indicator - that means an expression can be used such as defined in a variable or with a function.

Note that fx is not in the Label box.

Please let us know else we can help.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
ndeeleysww
Contributor

Re: Write Variable to Label

Thank Mike - least I know it's not possible yet.

Cheers

Neil

vadimtsushko
Contributor III

Re: Write Variable to Label

Take a look at this document for a possible solution Emulating dynamic labels in Qlik Sense

shannonmarshall
New Contributor

Re: Write Variable to Label

I do not see the extension on branch.qlik.com to download

vadimtsushko
Contributor III

Re: Write Variable to Label

Link to github project is in the article. The project is not on the branch.

Community Browser