topic 3 expressions in QlikView https://community.qlik.com/t5/QlikView/3-expressions/m-p/214088#M67678 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have 3 expressions</P><P>1 Normal Users<BR />2 Advance Users<BR />3 Both Normal And Advance Users.<BR /><BR />I want to calculate Nr 1 and 2 and 3, and i do.<BR />Example:</P><P>1, 34<BR />2, 45<BR />3, 65<BR /><BR />If you are in category 1 you have taken 1 licens<BR />If you are in category 2 you have take 1 licens<BR />But if you are in catecory 3 you have taken 1 from category 1 and category 2</P><P>Can i calculate this in QV?</P></BODY></HTML> Mon, 12 Oct 2009 21:14:29 GMT johnan 2009-10-12T21:14:29Z 3 expressions https://community.qlik.com/t5/QlikView/3-expressions/m-p/214088#M67678 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have 3 expressions</P><P>1 Normal Users<BR />2 Advance Users<BR />3 Both Normal And Advance Users.<BR /><BR />I want to calculate Nr 1 and 2 and 3, and i do.<BR />Example:</P><P>1, 34<BR />2, 45<BR />3, 65<BR /><BR />If you are in category 1 you have taken 1 licens<BR />If you are in category 2 you have take 1 licens<BR />But if you are in catecory 3 you have taken 1 from category 1 and category 2</P><P>Can i calculate this in QV?</P></BODY></HTML> Mon, 12 Oct 2009 21:14:29 GMT https://community.qlik.com/t5/QlikView/3-expressions/m-p/214088#M67678 johnan 2009-10-12T21:14:29Z 3 expressions https://community.qlik.com/t5/QlikView/3-expressions/m-p/214089#M67679 <HTML><HEAD></HEAD><BODY><P>I cant understand you... can you publish a script with a example? Thanks.</P></BODY></HTML> Tue, 13 Oct 2009 00:04:43 GMT https://community.qlik.com/t5/QlikView/3-expressions/m-p/214089#M67679 2009-10-13T00:04:43Z Re:3 expressions https://community.qlik.com/t5/QlikView/3-expressions/m-p/214090#M67680 <HTML><HEAD></HEAD><BODY><P>Yes <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 13 Oct 2009 00:53:23 GMT https://community.qlik.com/t5/QlikView/3-expressions/m-p/214090#M67680 johnan 2009-10-13T00:53:23Z Re:3 expressions https://community.qlik.com/t5/QlikView/3-expressions/m-p/214091#M67681 <HTML><HEAD></HEAD><BODY><P>In your example, can't you check with an "IF" if a certain criteria is fullfilled? (Or use Flag or create a counter during load time?</P><P>For expression 1 in your file<BR />Count(if(Type=1 or Type=12,Type))</P><P>BR<BR />Hans</P></BODY></HTML> Tue, 13 Oct 2009 02:07:02 GMT https://community.qlik.com/t5/QlikView/3-expressions/m-p/214091#M67681 2009-10-13T02:07:02Z