0 Replies Latest reply: Dec 8, 2016 9:12 AM by Jamie Lim RSS

    Character constraint in expression field use for a trend chart

    Jamie Lim

      Hi,

       

      I have a trend chart on qlik sense that uses a measure with the following expression:

       

      If (getselectedcount(field1)=0,

      (expressionA),

      (expressionB))

       

      The problem is expressionA and expressionB are rather lengthy and I've run out of space. I have already used variables to handle parts of the expressions pertaining to date range. the other parts of the expressions are the set analysis that specify what to include, and what fields to sum etc.

       

      As this whole expression is used as a measure in a trend chart,I cannot use variables to take over the entire expression.

       

      Any idea how I can overcome this constraint?

       

      Regards,

      Jamie