topic Expression to ignore data from Excel sheet in App Development https://community.qlik.com/t5/App-Development/Expression-to-ignore-data-from-Excel-sheet/m-p/1020790#M15383 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have 3 excel sheets loaded into my QlikSense file: </P><P>Test Sheet</P><P>Test Sheet 2</P><P>Dummy</P><P></P><P>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. </P><P></P><P>The expression I have is: </P><P>Count([Proposition Area])</P><P></P><P>Is there something I can put in this expression so that it ignores data from the sheet called Dummy? </P><P></P><P>Let me know if you have any questions or if this does not make sense.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 26 Apr 2016 09:14:59 GMT 2016-04-26T09:14:59Z Expression to ignore data from Excel sheet https://community.qlik.com/t5/App-Development/Expression-to-ignore-data-from-Excel-sheet/m-p/1020790#M15383 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have 3 excel sheets loaded into my QlikSense file: </P><P>Test Sheet</P><P>Test Sheet 2</P><P>Dummy</P><P></P><P>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. </P><P></P><P>The expression I have is: </P><P>Count([Proposition Area])</P><P></P><P>Is there something I can put in this expression so that it ignores data from the sheet called Dummy? </P><P></P><P>Let me know if you have any questions or if this does not make sense.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 26 Apr 2016 09:14:59 GMT https://community.qlik.com/t5/App-Development/Expression-to-ignore-data-from-Excel-sheet/m-p/1020790#M15383 2016-04-26T09:14:59Z