topic Problem with Diogram choose!!! in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372043#M618190 <HTML><HEAD></HEAD><BODY><P>Hi, Guys! <BR />I need your help for solving one task! <BR />The Task: Display the information about Employees, Offices and Sales which in Last month were sold better then in previous. (Graphically)</P><P></P><P>I know the solution of this Task in SQL-Server, but in QV I can't understand how to show it in diagram and which diagram I should choose for this type of data.</P></BODY></HTML> Fri, 05 May 2017 10:39:06 GMT 2017-05-05T10:39:06Z Problem with Diogram choose!!! https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372043#M618190 <HTML><HEAD></HEAD><BODY><P>Hi, Guys! <BR />I need your help for solving one task! <BR />The Task: Display the information about Employees, Offices and Sales which in Last month were sold better then in previous. (Graphically)</P><P></P><P>I know the solution of this Task in SQL-Server, but in QV I can't understand how to show it in diagram and which diagram I should choose for this type of data.</P></BODY></HTML> Fri, 05 May 2017 10:39:06 GMT https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372043#M618190 2017-05-05T10:39:06Z Re: Problem with Diogram choose!!! https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372044#M618191 <HTML><HEAD></HEAD><BODY><P>Then, Share me the query in SQL Server. We may convert into Qv as your manner <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 05 May 2017 10:43:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372044#M618191 Anil_Babu_Samineni 2017-05-05T10:43:42Z Re: Problem with Diogram choose!!! https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372045#M618192 <HTML><HEAD></HEAD><BODY><P>Actually, I'm not sure which columns I should to select. May be I didn't understand the Task at all. <BR />There should be something like that:<BR />Select [Employyes].[FullName], [Officess].[OfficeName], [Sales].[SalesDate] FROM Sales Left Join ...&nbsp; WHERE ... (Here should be the conditions for Months)???</P><P></P><P>Am I right?</P></BODY></HTML> Fri, 05 May 2017 10:53:12 GMT https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372045#M618192 2017-05-05T10:53:12Z Re: Problem with Diogram choose!!! https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372046#M618194 <HTML><HEAD></HEAD><BODY><P>Assume, This helps you and make sure, You can use joins directly here as per your need</P><P><A href="https://community.qlik.com/docs/DOC-7963">Do you Qualify?- How to use QUALIFY statement</A></P></BODY></HTML> Fri, 05 May 2017 10:55:10 GMT https://community.qlik.com/t5/QlikView/Problem-with-Diogram-choose/m-p/1372046#M618194 Anil_Babu_Samineni 2017-05-05T10:55:10Z