topic Re: Count from different database in QlikView https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974800#M959718 <HTML><HEAD></HEAD><BODY><P>If there is no relation how do you know which Qty belong to which Balance?</P></BODY></HTML> Tue, 27 Oct 2015 22:10:32 GMT robert_mika 2015-10-27T22:10:32Z Count from different database https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974799#M959717 <HTML><HEAD></HEAD><BODY><P>i have [QTY Available] and [Balance] and there is no relations between them.</P><P>i want to make calculation between them, COUNT(<SPAN style="font-size: 13.3333px;">[QTY Available] /<SPAN style="font-size: 13.3333px;">[Balance]) =New Record</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">how can i make it and get accurate result ?</SPAN></P><P><IMG alt="gggd.png" class="jive-image image-1" height="411" src="https://community.qlik.com/legacyfs/online/103214_gggd.png" style="height: 411.044px; width: 789px;" width="789" /></P></BODY></HTML> Tue, 27 Oct 2015 19:45:28 GMT https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974799#M959717 Anonymous 2015-10-27T19:45:28Z Re: Count from different database https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974800#M959718 <HTML><HEAD></HEAD><BODY><P>If there is no relation how do you know which Qty belong to which Balance?</P></BODY></HTML> Tue, 27 Oct 2015 22:10:32 GMT https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974800#M959718 robert_mika 2015-10-27T22:10:32Z Re: Count from different database https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974801#M959719 <HTML><HEAD></HEAD><BODY><P>i want to select Qty &amp; Balance then got the calculation for them as new record. it can't be ?!!</P></BODY></HTML> Wed, 28 Oct 2015 05:53:04 GMT https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974801#M959719 Anonymous 2015-10-28T05:53:04Z Re: Count from different database https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974802#M959720 <HTML><HEAD></HEAD><BODY><P>&gt;&gt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">i want to select Qty &amp; Balance then got the calculation for them as new record. it can't be ?!!</SPAN></P><P></P><P>I don't understand what you are trying to say. I suggest that you upload a qvw with some sample data and provide some examples to help explain what you are trying to do.</P></BODY></HTML> Wed, 28 Oct 2015 05:57:27 GMT https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974802#M959720 jonathandienst 2015-10-28T05:57:27Z Re: Count from different database https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974803#M959721 <HTML><HEAD></HEAD><BODY><P>sorry forget the discussion, i solve the problem and i write a wrong question here. sorry for that.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 28 Oct 2015 06:23:51 GMT https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974803#M959721 Anonymous 2015-10-28T06:23:51Z Re: Count from different database https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974804#M959722 <HTML><HEAD></HEAD><BODY><P>Try editing the thread and if possible just mark your reply as answered.</P></BODY></HTML> Wed, 28 Oct 2015 06:50:52 GMT https://community.qlik.com/t5/QlikView/Count-from-different-database/m-p/974804#M959722 sujeetsingh 2015-10-28T06:50:52Z