topic Combining formulae in QlikView https://community.qlik.com/t5/QlikView/Combining-formulae/m-p/997225#M953608 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to combine these two formulae.</P><P></P><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Revenue]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">"&gt;0"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}&gt;} </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Student No]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN></LI><LI><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">Details</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">='Hockey',</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Hockey]) </SPAN></LI></OL><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">The formula in point 2. Should replace the </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Revenue] </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">in the formula in point 1.</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Tried, </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">Details</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">='Hockey',</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Hockey])</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">"&gt;0"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}&gt;} </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Student No]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)</SPAN></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Any suggestions are welcome.</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Thank you<BR /></SPAN></P></BODY></HTML> Fri, 27 Nov 2015 11:01:26 GMT 2015-11-27T11:01:26Z Combining formulae https://community.qlik.com/t5/QlikView/Combining-formulae/m-p/997225#M953608 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to combine these two formulae.</P><P></P><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Revenue]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">"&gt;0"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}&gt;} </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Student No]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN></LI><LI><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">Details</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">='Hockey',</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Hockey]) </SPAN></LI></OL><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">The formula in point 2. Should replace the </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Revenue] </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">in the formula in point 1.</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Tried, </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">Details</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">='Hockey',</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Hockey])</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">"&gt;0"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}&gt;} </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[Student No]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)</SPAN></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Any suggestions are welcome.</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Thank you<BR /></SPAN></P></BODY></HTML> Fri, 27 Nov 2015 11:01:26 GMT https://community.qlik.com/t5/QlikView/Combining-formulae/m-p/997225#M953608 2015-11-27T11:01:26Z Re: Combining formulae https://community.qlik.com/t5/QlikView/Combining-formulae/m-p/997226#M953609 <HTML><HEAD></HEAD><BODY><P>Not sure what you're trying to do. Perhaps this is what you're looking for:<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;"><BR /></SPAN></P><P><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">({$&lt;Details={'Hockey'},</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Revenue]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">"&gt;0"</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">}&gt;} </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Student No]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">)</SPAN></P></BODY></HTML> Fri, 27 Nov 2015 12:53:30 GMT https://community.qlik.com/t5/QlikView/Combining-formulae/m-p/997226#M953609 Gysbert_Wassenaar 2015-11-27T12:53:30Z