topic Re: SET ANALYSIS in QlikView https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308330#M830874 <HTML><HEAD></HEAD><BODY><P>How you want in layout orient?</P></BODY></HTML> Sat, 17 Jun 2017 06:35:43 GMT Anil_Babu_Samineni 2017-06-17T06:35:43Z SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308329#M830873 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>I have the consultant revenue and patient id .I want to find</P><P>1.the consultant who attended less patient and earned more revenue.</P><P>2.the consultant who attended more patient and earned more revenue.</P><P>3.the consultant who attended less patient and earned less revenue.</P><P>4.the consultant who attended more patient and earned less revenue.</P><P></P><P>PFA </P><P></P><P>ptid is patient id and bill net amount is the revenue.</P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308329#M830873 ajsjoshua 2020-11-25T16:16:04Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308330#M830874 <HTML><HEAD></HEAD><BODY><P>How you want in layout orient?</P></BODY></HTML> Sat, 17 Jun 2017 06:35:43 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308330#M830874 Anil_Babu_Samineni 2017-06-17T06:35:43Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308331#M830875 <HTML><HEAD></HEAD><BODY><P>Dear Anil,</P><P></P><P>I want display it in bar chart.</P></BODY></HTML> Sat, 17 Jun 2017 06:39:35 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308331#M830875 ajsjoshua 2017-06-17T06:39:35Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308332#M830876 <HTML><HEAD></HEAD><BODY><P>Can you explain the logic behind for 1 sentence atleast </P></BODY></HTML> Sat, 17 Jun 2017 06:42:11 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308332#M830876 Anil_Babu_Samineni 2017-06-17T06:42:11Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308333#M830877 <HTML><HEAD></HEAD><BODY><P>Hello, Joshua!</P><P></P><P>Such tasks can be easily solved with scatter chart:</P><P><IMG __jive_id="167178" alt="distrib.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167178_distrib.png" style="height: 361px; width: 620px;" /></P><P>I used randomly generated data so there is a diagonal. But dimension and expressions are suits for you.</P><P>PFA</P></BODY></HTML> Sat, 17 Jun 2017 06:57:10 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308333#M830877 Sergey_Shuklin 2017-06-17T06:57:10Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308334#M830878 <HTML><HEAD></HEAD><BODY><P>On your data it will be like this:</P><P><IMG alt="cons_distr_2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167179_cons_distr_2.png" style="height: 296px; width: 620px;" /></P><P>Gray lines is 66-percentile.</P></BODY></HTML> Sat, 17 Jun 2017 07:19:39 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1308334#M830878 Sergey_Shuklin 2017-06-17T07:19:39Z