Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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.