topic class function and Total in QlikView https://community.qlik.com/t5/QlikView/class-function-and-Total/m-p/353644#M131211 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P></P><P>I made a bar chart, I wuold like to use, as dimension, class function:</P><P></P><P>=class(?????,$(VClassTotalOrder),'Imp.')</P><P></P><P>what I write in ?????, if I would have the Total of the order?</P><P></P><P>I have these data:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="162" style="border: 1px solid rgb(0, 0, 0); width: 395px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">N°Order</TH><TH align="center" style="background-color: #6690bc;" valign="middle">Product</TH><TH align="center" style="background-color: #6690bc;" valign="middle">ProductPrice</TH></TR><TR><TD>11111</TD><TD>Pen</TD><TD>1,00</TD></TR><TR><TD>11111</TD><TD>Rubber</TD><TD>4,00</TD></TR><TR><TD>22222</TD><TD>Paper</TD><TD>3,00</TD></TR><TR><TD>33333</TD><TD>Paper</TD><TD>3,00</TD></TR><TR><TD>33333</TD><TD>Bag</TD><TD>15,00</TD></TR><TR><TD>33333</TD><TD>Pencil</TD><TD>2,00</TD></TR></TBODY></TABLE><P></P><P></P><P>Thank you!</P></BODY></HTML> Thu, 14 Jun 2012 15:17:49 GMT andyrebs 2012-06-14T15:17:49Z class function and Total https://community.qlik.com/t5/QlikView/class-function-and-Total/m-p/353644#M131211 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P></P><P>I made a bar chart, I wuold like to use, as dimension, class function:</P><P></P><P>=class(?????,$(VClassTotalOrder),'Imp.')</P><P></P><P>what I write in ?????, if I would have the Total of the order?</P><P></P><P>I have these data:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="162" style="border: 1px solid rgb(0, 0, 0); width: 395px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">N°Order</TH><TH align="center" style="background-color: #6690bc;" valign="middle">Product</TH><TH align="center" style="background-color: #6690bc;" valign="middle">ProductPrice</TH></TR><TR><TD>11111</TD><TD>Pen</TD><TD>1,00</TD></TR><TR><TD>11111</TD><TD>Rubber</TD><TD>4,00</TD></TR><TR><TD>22222</TD><TD>Paper</TD><TD>3,00</TD></TR><TR><TD>33333</TD><TD>Paper</TD><TD>3,00</TD></TR><TR><TD>33333</TD><TD>Bag</TD><TD>15,00</TD></TR><TR><TD>33333</TD><TD>Pencil</TD><TD>2,00</TD></TR></TBODY></TABLE><P></P><P></P><P>Thank you!</P></BODY></HTML> Thu, 14 Jun 2012 15:17:49 GMT https://community.qlik.com/t5/QlikView/class-function-and-Total/m-p/353644#M131211 andyrebs 2012-06-14T15:17:49Z Re: class function and Total https://community.qlik.com/t5/QlikView/class-function-and-Total/m-p/353645#M131212 <HTML><HEAD></HEAD><BODY><P>Try maybe</P><P></P><P>=aggr( class( sum[ProductPrice] ,$(VClassTotalOrder),'Imp.'), [N°Order])</P></BODY></HTML> Thu, 14 Jun 2012 15:28:55 GMT https://community.qlik.com/t5/QlikView/class-function-and-Total/m-p/353645#M131212 swuehl 2012-06-14T15:28:55Z Re: class function and Total https://community.qlik.com/t5/QlikView/class-function-and-Total/m-p/353646#M131213 <HTML><HEAD></HEAD><BODY><P>Yes, It works!</P><P></P><P>Thanks</P></BODY></HTML> Thu, 14 Jun 2012 15:38:33 GMT https://community.qlik.com/t5/QlikView/class-function-and-Total/m-p/353646#M131213 andyrebs 2012-06-14T15:38:33Z