topic Re: Need help on filtering Data in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-filtering-Data/m-p/710148#M255852 <HTML><HEAD></HEAD><BODY><P>When I load the Excel data from Goal.xlsx into a new qvw and chart it, I get the correct total for YTD Goal for Shanghai Sales of 50,688,328</P></BODY></HTML> Tue, 28 Oct 2014 12:16:26 GMT m_woolf 2014-10-28T12:16:26Z Need help on filtering Data https://community.qlik.com/t5/QlikView/Need-help-on-filtering-Data/m-p/710147#M255851 <HTML><HEAD></HEAD><BODY><P>Hi Qv,</P><P></P><P>I have a bar chart and straight table in my dashboard.</P><P>Please find attached, In this I'm getting Revenue properly but problem is with the Goal.</P><P>I have verified source data, charts are displaying Goal more than the actual Goal present in the source file,</P><P>Could you please help me out from where it is picking up the goal.</P><P></P><P>Thanks,</P><P>Ananth</P><P><IMG alt="goal_sc.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69846_goal_sc.png" style="width: 620px; height: 388px;" /> </P><P><IMG alt="Goal_Data.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69847_Goal_Data.png" style="width: 620px; height: 388px;" /></P></BODY></HTML> Tue, 28 Oct 2014 11:30:40 GMT https://community.qlik.com/t5/QlikView/Need-help-on-filtering-Data/m-p/710147#M255851 2014-10-28T11:30:40Z Re: Need help on filtering Data https://community.qlik.com/t5/QlikView/Need-help-on-filtering-Data/m-p/710148#M255852 <HTML><HEAD></HEAD><BODY><P>When I load the Excel data from Goal.xlsx into a new qvw and chart it, I get the correct total for YTD Goal for Shanghai Sales of 50,688,328</P></BODY></HTML> Tue, 28 Oct 2014 12:16:26 GMT https://community.qlik.com/t5/QlikView/Need-help-on-filtering-Data/m-p/710148#M255852 m_woolf 2014-10-28T12:16:26Z