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

    Expression to ignore data from Excel sheet

      Hi All,


      I have 3 excel sheets loaded into my QlikSense file:

      Test Sheet

      Test Sheet 2



      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.