Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
uma_maheswari
New 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

Tags (1)
1 Reply
MVP
MVP

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

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.