Write Variable to Label

[ndeeleysww]

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

[#2]

Try this on the label..

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

[nagarjuna_kotha]

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]

Hi,

Also u can use like this.

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

Regards,

Nagarjuna

[ndeeleysww]

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

[Michael_Tarallo · Accepted solution]

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

[ndeeleysww]

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

Cheers

Neil

[vadimtsushko]

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

[shannonmarshall]

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

[vadimtsushko]

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