1 Reply Latest reply: Aug 16, 2017 10:17 AM by Petter Skjolden RSS

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

    Uma K

      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

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

          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.