Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
uma_maheswari
Contributor III
Contributor III

Is it possible to change the Straight table Label dynamically in QlikSense ?

Hi All,

I tried to change the Label dynamically in Pivot table- Label ,for the measures part ,that works like a charm .

$(=Vyear) in Label

I am unable to change it in Straight table .

Please provide a suggestion on the same .

Thanks ,

Uma

1 Reply
petter
Partner - Champion III
Partner - Champion III

An ugly hack would be to create a measure to check if the row of the table is the TOTALS row and if it is display a text label there that could be an expression aka as dynamic. Then you can put a period or other tiny character into the label which is to be as invisible as possible. Lastly you put a space instead of the word Totals into the placeholder/label too.

This way you lose the ability to display totals but you get the ability to have dynamic labels.

The expression you can use is:

=If( IsNull(RowNo()), 'Dynamic Sales label #' & (-1+2) , Sum( Sales ) )

So if the RowNo() function returns a Null value the table is at the Totals row and you want to calculate a specific expression to display a dynamic label. If the row number is not null then it is a regular row and should calculate the normal expression.