topic create groups by variables in pivot table in QlikView

topic create groups by variables in pivot table in QlikView https://community.qlik.com/t5/QlikView/create-groups-by-variables-in-pivot-table/m-p/1413122#M512515 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Is it possible to create groups by variables in pivot table?</P><P>Variables are loading from excel file.</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" dir="ltr" style="font-size: 10pt; font-family: arial, sans, sans-serif; border: none;"><TBODY><TR><TD style="border-width: 1px; border-style: solid; border-color: #000000; padding-right: 3px; padding-left: 3px;"></TD><TD style="border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;"></TD><TD colspan="3" data-sheets-value="{"1":2,"2":"Group1"}" rowspan="1" style="border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold; text-align: center;">Group1</TD><TD colspan="3" data-sheets-value="{"1":2,"2":"Group2"}" rowspan="1" style="border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold; text-align: center;">Group2</TD></TR><TR><TD data-sheets-value="{"1":2,"2":"Dimension1"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">Dimension1</TD><TD data-sheets-value="{"1":2,"2":"Dimension2"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">Dimension2</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable1)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable1)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable2)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable2)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable3)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable3)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable3)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable3)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable2)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable2)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable3)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable3)</TD></TR><TR><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD></TR><TR><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD></TR></TBODY></TABLE></BODY></HTML> Sun, 05 Nov 2017 19:56:00 GMT maxsheva 2017-11-05T19:56:00Z create groups by variables in pivot table https://community.qlik.com/t5/QlikView/create-groups-by-variables-in-pivot-table/m-p/1413122#M512515 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Is it possible to create groups by variables in pivot table?</P><P>Variables are loading from excel file.</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" dir="ltr" style="font-size: 10pt; font-family: arial, sans, sans-serif; border: none;"><TBODY><TR><TD style="border-width: 1px; border-style: solid; border-color: #000000; padding-right: 3px; padding-left: 3px;"></TD><TD style="border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;"></TD><TD colspan="3" data-sheets-value="{"1":2,"2":"Group1"}" rowspan="1" style="border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold; text-align: center;">Group1</TD><TD colspan="3" data-sheets-value="{"1":2,"2":"Group2"}" rowspan="1" style="border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold; text-align: center;">Group2</TD></TR><TR><TD data-sheets-value="{"1":2,"2":"Dimension1"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">Dimension1</TD><TD data-sheets-value="{"1":2,"2":"Dimension2"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">Dimension2</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable1)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable1)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable2)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable2)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable3)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable3)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable3)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable3)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable2)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable2)</TD><TD data-sheets-value="{"1":2,"2":"`=$(Variable3)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px; font-weight: bold;">`=$(Variable3)</TD></TR><TR><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD></TR><TR><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Value"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Value</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD><TD data-sheets-value="{"1":2,"2":"Sum(Value)"}" style="border-right: 1px solid #000000; border-bottom: 1px solid #000000; padding-right: 3px; padding-left: 3px;">Sum(Value)</TD></TR></TBODY></TABLE></BODY></HTML> Sun, 05 Nov 2017 19:56:00 GMT https://community.qlik.com/t5/QlikView/create-groups-by-variables-in-pivot-table/m-p/1413122#M512515 maxsheva 2017-11-05T19:56:00Z