https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634155#M507177 <P>Holy my.. I've really been staring myself blind!</P><P>Huge tank you!</P> Fri, 11 Oct 2019 09:46:43 GMT EmiliaP 2019-10-11T09:46:43Z https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634144#M507175 <P>Hi!</P><P>I have a issue where the dimensions of a pivot table just jumps around and I cannot sort the data according to demands.</P><P>I would like to sort it ascending (not any rocket science there), but when I add multiple levels of groups the data does not apply to the rules. What am I missing?</P> Sat, 16 Nov 2024 19:55:00 GMT https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634144#M507175 EmiliaP 2024-11-16T19:55:00Z https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634151#M507176 <P>Hi,</P><P>I am not sure, but...like file attached?</P><P>&nbsp;</P> Fri, 11 Oct 2019 09:37:48 GMT https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634151#M507176 StarinieriG 2019-10-11T09:37:48Z https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634155#M507177 <P>Holy my.. I've really been staring myself blind!</P><P>Huge tank you!</P> Fri, 11 Oct 2019 09:46:43 GMT https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634155#M507177 EmiliaP 2019-10-11T09:46:43Z https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634502#M507178 <P>Hi,</P><P>i have taken sample data wrt. your fields</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_3.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21337i698CF514399D3B77/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_3.png" alt="clipboard_image_3.png" /></span></P><P>&nbsp;</P><P>FOR PIVOT&nbsp;&nbsp;Dimension, Column, Measure as below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_1.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21335i91B78BFB80C03A70/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_1.png" alt="clipboard_image_1.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_2.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21336iFD1932DE6EFCA6C7/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_2.png" alt="clipboard_image_2.png" /></span></P><P>result will be below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21334iFB74568A9826392A/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P><P>i think its help to solve your prob......</P><P>K. Srinivasan.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 12 Oct 2019 08:58:57 GMT https://community.qlik.com/t5/QlikView/Cyclic-groups-as-Pivot-table-makes-the-dimension-data-jump/m-p/1634502#M507178 Ksrinivasan 2019-10-12T08:58:57Z