topic How to write the query ? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89930#M764829 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><H1 class="bNiwgl sc-hkBaHy" style="color: #172b4d; font-size: 1.71429em; font-weight: 500; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; background-color: #f4f5f7;">Pull a report of all institutions that have more than one active consultant relationship.</H1><P></P><P><SPAN style="color: #172b4d; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; background-color: #f4f5f7;">A consultant has the CONSULTANT (id 6 in relationshiptype) relationship type to its institution in relationship with status_id = 2</SPAN></P><P><SPAN style="color: #172b4d; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; background-color: #f4f5f7;"><BR /></SPAN></P><P><SPAN style="color: #172b4d; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; background-color: #f4f5f7;">Thanks,<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT suvechha_b 2020-11-25T16:16:04Z How to write the query ? https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89930#M764829 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><H1 class="bNiwgl sc-hkBaHy" style="color: #172b4d; font-size: 1.71429em; font-weight: 500; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; background-color: #f4f5f7;">Pull a report of all institutions that have more than one active consultant relationship.</H1><P></P><P><SPAN style="color: #172b4d; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; background-color: #f4f5f7;">A consultant has the CONSULTANT (id 6 in relationshiptype) relationship type to its institution in relationship with status_id = 2</SPAN></P><P><SPAN style="color: #172b4d; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; background-color: #f4f5f7;"><BR /></SPAN></P><P><SPAN style="color: #172b4d; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; background-color: #f4f5f7;">Thanks,<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89930#M764829 suvechha_b 2020-11-25T16:16:04Z Re: How to write the query ? https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89931#M764830 <HTML><HEAD></HEAD><BODY><P>Where is this query needed? Front end or back end? Can you provide more information?</P></BODY></HTML> Mon, 16 Jul 2018 11:55:09 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89931#M764830 sunny_talwar 2018-07-16T11:55:09Z Re: How to write the query ? https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89932#M764831 <HTML><HEAD></HEAD><BODY><P>I need this in back end .</P><P>We got table relationship where institution_id , relationshiptype_id , status_id and member_id is present .</P><P></P><P>Consultant = relationshiptype_id&nbsp; (6)</P><P>Status = status_id&nbsp; (2)</P></BODY></HTML> Mon, 16 Jul 2018 12:04:14 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89932#M764831 suvechha_b 2018-07-16T12:04:14Z Re: How to write the query ? https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89933#M764832 <HTML><HEAD></HEAD><BODY><P>it's good if u can provide ur input data and expected out!</P></BODY></HTML> Mon, 16 Jul 2018 12:26:07 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-query/m-p/89933#M764832 buzzy996 2018-07-16T12:26:07Z