1 Reply Latest reply: Feb 2, 2018 4:12 PM by Jessica Tung RSS

    QlikSense dynamic expression label

    Jessica Tung

      Hi, I want to display different labels for the same expression under the same dimension.

      For example:

      Dimension - Product Type - value: Loans, Revenue

      Expression - If [Product Type]='Loans', sales of this month,

                           If [Product Type]='Revenue', sales of YTD

                           sum(sales of Loans of this month) + sum(sales of Revenue of YTD)

      I want to display Nov '17 for Loans, and Nov '17 YTD for Revenue, how do I do that?

      I tried if, aggr, set analysis with P, but none of them worked because they don't recognize the dimension.

      Dynamic label works at app level.

      Dynamic Label.pngDynamic Label2.PNG