topic Help needed in QlikView https://community.qlik.com/t5/QlikView/Help-needed/m-p/252787#M95840 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>I have data like this</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;"><TBODY><TR><TD style="padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black; border-style: solid;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">trnType</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">DocNo.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Date</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Party</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Qty.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Amount</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Sales</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">INV/001</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">01/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">XYZ &amp; Co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 1</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">50</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">500</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Sales</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">INV/002</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">02/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">ABC &amp; Co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 2</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">100</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">1000</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Return</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">RET/001</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">01/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">XYZ &amp; co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 1</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">10</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">100</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Return</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">RET/002</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">02/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">ABC &amp; Co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 2</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">10</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">100</P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P>In a straight table chart I want to show only Sales data and in anotherI want to show Return data, How I don't know.</P><P><SPAN style="font-family: Calibri, sans-serif; font-size: 11pt;">Please Help me.</SPAN></P><P></P><P><SPAN style="font-family: Calibri, sans-serif; font-size: 11pt;">anil<BR /></SPAN></P></BODY></HTML> Mon, 17 Oct 2011 09:53:57 GMT 2011-10-17T09:53:57Z Help needed https://community.qlik.com/t5/QlikView/Help-needed/m-p/252787#M95840 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>I have data like this</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;"><TBODY><TR><TD style="padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black; border-style: solid;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">trnType</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">DocNo.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Date</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Party</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Qty.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: solid; border-right-style: none; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Amount</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Sales</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">INV/001</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">01/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">XYZ &amp; Co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 1</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">50</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">500</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Sales</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">INV/002</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">02/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">ABC &amp; Co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 2</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">100</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">1000</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Return</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">RET/001</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">01/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">XYZ &amp; co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 1</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">10</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">100</P>&nbsp; </TD></TR><TR><TD style="border-width: initial; border-color: initial; border-top-width: initial; border-top-color: initial; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-style: none;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Return</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">RET/002</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">02/04/2011</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">ABC &amp; Co.</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">Product 2</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">10</P>&nbsp; </TD><TD style="border-style: initial; border-top-style: none; border-right-style: solid; border-bottom-style: solid; border-left-style: none; padding-top: 0px; padding-bottom: 0px; padding-left: 5.4pt; padding-right: 5.4pt; border-width: 1pt; border-color: black;" valign="top" width="88"> <P style="margin-bottom: 0.0001pt;">100</P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P>In a straight table chart I want to show only Sales data and in anotherI want to show Return data, How I don't know.</P><P><SPAN style="font-family: Calibri, sans-serif; font-size: 11pt;">Please Help me.</SPAN></P><P></P><P><SPAN style="font-family: Calibri, sans-serif; font-size: 11pt;">anil<BR /></SPAN></P></BODY></HTML> Mon, 17 Oct 2011 09:53:57 GMT https://community.qlik.com/t5/QlikView/Help-needed/m-p/252787#M95840 2011-10-17T09:53:57Z Help needed https://community.qlik.com/t5/QlikView/Help-needed/m-p/252788#M95841 <HTML><HEAD></HEAD><BODY><P>One way would be to use a calculated dimension like</P><P></P><P>=if(tmType = 'Sales', tmType)</P><P></P><P>and suppress NULL on dimensions. Similar for Return type.</P><P></P><P>Another way would be using set analysis in the expressions, like</P><P>sum({&lt;tmType = {'Sales'}&gt;} Amount)</P><P></P><P>Similar for all other expressions.</P><P></P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Mon, 17 Oct 2011 10:23:10 GMT https://community.qlik.com/t5/QlikView/Help-needed/m-p/252788#M95841 swuehl 2011-10-17T10:23:10Z