0 Replies Latest reply: Apr 26, 2016 5:14 AM by Patrice Veasey RSS

    Expression to ignore data from Excel sheet

    Patrice Veasey

      Hi All,

       

      I have 3 excel sheets loaded into my QlikSense file:

      Test Sheet

      Test Sheet 2

      Dummy

       

      Dummy has data on it that I don't want to use within the chart I am trying to create however I need the sheet loaded in for other reasons.

       

      The expression I have is:

      Count([Proposition Area])

       

      Is there something I can put in this expression so that it ignores data from the sheet called Dummy?

       

      Let me know if you have any questions or if this does not make sense.

       

      Thanks!