Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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!

0 Replies