topic Re: whats wrong with this expression in QlikView https://community.qlik.com/t5/QlikView/whats-wrong-with-this-expression/m-p/381549#M142352 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think you need:</P><P></P><P><EM>if(Keynumber='Orders',count(order_id),</EM></P><P><EM>if(Keynumber='Revenue',sum(amount),</EM></P><P><EM>if(Keynumber='Conversion',sum(first),</EM></P><P><EM>if(Keynumber='New Users',count(DISTINCT user_id),</EM></P><P><EM>if(Keynumber='New Subscriptions',sum(new)-sum(cancelled))))))</EM></P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Tue, 28 Aug 2012 12:53:07 GMT jonathandienst 2012-08-28T12:53:07Z whats wrong with this expression https://community.qlik.com/t5/QlikView/whats-wrong-with-this-expression/m-p/381548#M142351 <HTML><HEAD></HEAD><BODY><P>it says error in this expression, but I don't know why:</P><P></P><P>if(Keynumber='Orders',count(order_id),</P><P></P><P></P><P>if(Keynumber='Revenue',sum(amount),</P><P></P><P></P><P>if(Keynumber='Conversion',sum(first),</P><P></P><P></P><P>if(Keynumber='New Users',count(DISTINCT(user_id),</P><P></P><P></P><P>if(Keynumber='New Subscriptions',sum(new)-sum(cancelled)))))))</P></BODY></HTML> Tue, 28 Aug 2012 12:49:06 GMT https://community.qlik.com/t5/QlikView/whats-wrong-with-this-expression/m-p/381548#M142351 2012-08-28T12:49:06Z Re: whats wrong with this expression https://community.qlik.com/t5/QlikView/whats-wrong-with-this-expression/m-p/381549#M142352 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think you need:</P><P></P><P><EM>if(Keynumber='Orders',count(order_id),</EM></P><P><EM>if(Keynumber='Revenue',sum(amount),</EM></P><P><EM>if(Keynumber='Conversion',sum(first),</EM></P><P><EM>if(Keynumber='New Users',count(DISTINCT user_id),</EM></P><P><EM>if(Keynumber='New Subscriptions',sum(new)-sum(cancelled))))))</EM></P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Tue, 28 Aug 2012 12:53:07 GMT https://community.qlik.com/t5/QlikView/whats-wrong-with-this-expression/m-p/381549#M142352 jonathandienst 2012-08-28T12:53:07Z