topic Re: Hi! in QlikView https://community.qlik.com/t5/QlikView/Hi/m-p/557331#M1124275 <HTML><HEAD></HEAD><BODY><P>Not sure if this is what you're looking for. If it doesn't help, try to explain what you are trying to achieve. Grouped your products in loadscript rather than in chart. Are you trying to group your products based on the previous product's share?</P><P></P><P>PFA</P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 06 Jan 2014 15:20:00 GMT jerem1234 2014-01-06T15:20:00Z Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557326#M1124265 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="294"><TBODY><TR><TD class="xl63" height="17" width="98">GroopABC</TD><TD class="xl64" style="border-left: none;" width="98">product</TD><TD class="xl65" width="98">ABC</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">А</TD><TD class="xl65" style="border-top: none; border-left: none;">product 1</TD><TD class="xl65" style="border-top: none; border-left: none;">А</TD></TR><TR><TD class="xl66" height="51" rowspan="3" style="border-bottom: .5pt solid gainsboro; border-top: none;">С</TD><TD class="xl65" style="border-top: none; border-left: none;">product 2</TD><TD class="xl65" style="border-top: none; border-left: none;">С</TD></TR><TR><TD class="xl65" height="17" style="border-top: none; border-left: none;">product 3</TD><TD class="xl65" style="border-top: none; border-left: none;">С</TD></TR><TR><TD class="xl65" height="17" style="border-top: none; border-left: none;">product 4</TD><TD class="xl65" style="border-top: none; border-left: none;">С</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 06 Jan 2014 14:46:59 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557326#M1124265 2014-01-06T14:46:59Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557327#M1124268 <HTML><HEAD></HEAD><BODY><P>need help.</P><P>possible to make the pivot table in a file, as in Table Excel?</P></BODY></HTML> Mon, 06 Jan 2014 14:47:37 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557327#M1124268 2014-01-06T14:47:37Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557328#M1124271 <HTML><HEAD></HEAD><BODY><P>Have you tried straight table?</P></BODY></HTML> Mon, 06 Jan 2014 14:52:02 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557328#M1124271 MK_QSL 2014-01-06T14:52:02Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557329#M1124273 <HTML><HEAD></HEAD><BODY><P>yes, but without result.</P></BODY></HTML> Mon, 06 Jan 2014 14:54:42 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557329#M1124273 2014-01-06T14:54:42Z Re: Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557330#M1124274 <HTML><HEAD></HEAD><BODY><P>Am not clear about your requirement.</P><P>Please find the attachment.</P><P>Is this what you need?</P></BODY></HTML> Mon, 06 Jan 2014 14:55:12 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557330#M1124274 sundarakumar 2014-01-06T14:55:12Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557331#M1124275 <HTML><HEAD></HEAD><BODY><P>Not sure if this is what you're looking for. If it doesn't help, try to explain what you are trying to achieve. Grouped your products in loadscript rather than in chart. Are you trying to group your products based on the previous product's share?</P><P></P><P>PFA</P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 06 Jan 2014 15:20:00 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557331#M1124275 jerem1234 2014-01-06T15:20:00Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557332#M1124276 <HTML><HEAD></HEAD><BODY><P>I need to create the summary table. the first column is groups of product: A, B, C.</P><P>we open them, we receive goods which belong to this group.</P><P>that is we have 4 product, one treats group 'A', the others group 'C'.</P><P>we open group of product 'A' we will see one goods, we open group of goods 'C' we will see all other products (2,3,4) </P><P></P><P></P><P>that is from these 3 columns to make 3 groups (A, B, C) - (it is our first column)</P></BODY></HTML> Mon, 06 Jan 2014 15:22:02 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557332#M1124276 2014-01-06T15:22:02Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557333#M1124277 <HTML><HEAD></HEAD><BODY><P>thank you very much</P></BODY></HTML> Mon, 06 Jan 2014 15:23:48 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557333#M1124277 2014-01-06T15:23:48Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557334#M1124278 <HTML><HEAD></HEAD><BODY><P>small question.</P><P>Can we prescribe rules PivotTable properties (through expressions and calculated measurement)?</P></BODY></HTML> Tue, 07 Jan 2014 08:52:08 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557334#M1124278 2014-01-07T08:52:08Z Re: Hi! https://community.qlik.com/t5/QlikView/Hi/m-p/557335#M1124279 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean by rules, could you explain a little more? If what you are asking is if it can be done using expression and calculated dimensions, then sure, there might be a way. The last two columns, product and ABC, would be easy to do. But for the first column of GroupABC, since there is no link between ABC and product, it would be hard and probably won't get you the table you want. The best way is to do in loadscript, so there is a link between ABC and product and then you can use it as a dimension and get only the products for that group.</P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 07 Jan 2014 13:46:29 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/557335#M1124279 jerem1234 2014-01-07T13:46:29Z