topic Re: Help with the function in QlikView https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434055#M161796 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 13 Dec 2012 12:01:20 GMT sivarajs 2012-12-13T12:01:20Z Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434045#M161786 <HTML><HEAD></HEAD><BODY><P>I have the following table:</P><P></P><P><STRONG style="text-decoration: underline;">itemid&nbsp;&nbsp;&nbsp;&nbsp; Cost</STRONG></P><P>99999&nbsp;&nbsp;&nbsp; 9</P><P>trans&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>trans&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P></P><P>I would like to count the items wich will be "trans" and with 0 cost</P><P>Count({&lt;[ITEMID]={'TRANS'}},{[COST]={'0'}&gt;})</P><P></P><P>Thank's everyone!!</P><P></P><P>Eduard</P></BODY></HTML> Thu, 13 Dec 2012 11:09:36 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434045#M161786 ecabanas 2012-12-13T11:09:36Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434046#M161787 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Something like</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count({&lt;[ITEMID]={'TRANS'}, [COST]={'0'}&gt;} Distinct itemid)</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Thu, 13 Dec 2012 11:12:33 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434046#M161787 jonathandienst 2012-12-13T11:12:33Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434047#M161788 <HTML><HEAD></HEAD><BODY><P>It doesn't work, no results found :s</P></BODY></HTML> Thu, 13 Dec 2012 11:20:28 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434047#M161788 ecabanas 2012-12-13T11:20:28Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434048#M161789 <HTML><HEAD></HEAD><BODY><P>Qlikview is case sensitive - adjust the expression to show the field names in the correct case.</P><P>Jonathan</P></BODY></HTML> Thu, 13 Dec 2012 11:23:09 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434048#M161789 jonathandienst 2012-12-13T11:23:09Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434049#M161790 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan,</P><P></P><P>I know the case sensitive problem, but this is not the problem, all is upper case!!!</P><P></P><P>and is still without working!!!</P><P></P><P>thank's for your patience!!!</P></BODY></HTML> Thu, 13 Dec 2012 11:33:19 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434049#M161790 ecabanas 2012-12-13T11:33:19Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434050#M161791 <HTML><HEAD></HEAD><BODY><P>Eduard</P><P></P><P>You will need to provide more information - is it returning null, zero or the wrong value? What is the actual expression you tried?</P><P></P><P>I suggest that you post your model or a sample illsutrating the problem so that it can be looked at in more detail.</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Thu, 13 Dec 2012 11:40:25 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434050#M161791 jonathandienst 2012-12-13T11:40:25Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434051#M161792 <HTML><HEAD></HEAD><BODY><P>Check the attachment</P></BODY></HTML> Thu, 13 Dec 2012 11:40:57 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434051#M161792 sivarajs 2012-12-13T11:40:57Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434052#M161793 <HTML><HEAD></HEAD><BODY><P>See the example attached, </P><P></P><P>thank you every one!!!</P></BODY></HTML> Thu, 13 Dec 2012 11:49:45 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434052#M161793 ecabanas 2012-12-13T11:49:45Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434053#M161794 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use below exp.. it is working for me..</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>count</P><P></P><P></P><P><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">itemid</SPAN><SPAN style="font-size: 8pt;">={'trans'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">Cost</SPAN><SPAN style="font-size: 8pt;">={0}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">itemid</SPAN></P><P><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P>Regards,</P><P>Chandra</P></BODY></HTML> Thu, 13 Dec 2012 11:54:50 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434053#M161794 2012-12-13T11:54:50Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434054#M161795 <HTML><HEAD></HEAD><BODY><P>Hi Chandra,</P><P></P><P>If I only use the first condition it works, but if I add the Cost condittion doesnt work!!! and this combination exists <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; background-color: #ffffff;">count <SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">itemid</SPAN><SPAN style="font-size: 8pt;">={'trans'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">Cost</SPAN><SPAN style="font-size: 8pt;">={0}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">itemid</SPAN><SPAN style="font-size: 8pt;">)</SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P>thank's</P></BODY></HTML> Thu, 13 Dec 2012 12:00:14 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434054#M161795 ecabanas 2012-12-13T12:00:14Z Re: Help with the function https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434055#M161796 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 13 Dec 2012 12:01:20 GMT https://community.qlik.com/t5/QlikView/Help-with-the-function/m-p/434055#M161796 sivarajs 2012-12-13T12:01:20Z