topic Re: Countif between in QlikView https://community.qlik.com/t5/QlikView/Countif-between/m-p/770738#M471971 <HTML><HEAD></HEAD><BODY><P>Try class() function:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/672906#672906" title="http://community.qlik.com/message/672906#672906">http://community.qlik.com/message/672906#672906</A></P></BODY></HTML> Mon, 09 Feb 2015 16:05:22 GMT robert_mika 2015-02-09T16:05:22Z Countif between https://community.qlik.com/t5/QlikView/Countif-between/m-p/770737#M471970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>please help me with expression.</P><P></P><P>I have invoices for all different cities with any value CZK.</P><P>I can sum values for every city,than i can count cities by distinct, but i cannot count cities with sum value between two target values.</P><P>For example Paris and Viena have their sums in rank 20 000 - 35 000,so i need to write "2".</P><P></P><P>Could you please suggest concrete function or little trick for this expresion.</P><P></P><P>Thx</P><P>Jaromir</P><P><IMG /></P></BODY></HTML> Mon, 09 Feb 2015 16:02:15 GMT https://community.qlik.com/t5/QlikView/Countif-between/m-p/770737#M471970 2015-02-09T16:02:15Z Re: Countif between https://community.qlik.com/t5/QlikView/Countif-between/m-p/770738#M471971 <HTML><HEAD></HEAD><BODY><P>Try class() function:</P><P><A _jive_internal="true" href="https://community.qlik.com/message/672906#672906" title="http://community.qlik.com/message/672906#672906">http://community.qlik.com/message/672906#672906</A></P></BODY></HTML> Mon, 09 Feb 2015 16:05:22 GMT https://community.qlik.com/t5/QlikView/Countif-between/m-p/770738#M471971 robert_mika 2015-02-09T16:05:22Z