topic Re: Issue with sorting data in zebra-chart in QlikView https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583591#M1118168 <HTML><HEAD></HEAD><BODY><P>It is because you use for the background the RowNo() function, this is linked to the natural sorting of rows that can't be resorted in other ways ...</P><P>You should use other logic to obtain a zebra graph</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 29 Jan 2014 14:02:36 GMT alexandros17 2014-01-29T14:02:36Z Issue with sorting data in zebra-chart https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583590#M1118167 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>I Created a simple chart and painted rows as follows</P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52286_Capture.PNG.png" style="width: 620px; height: 547px;" /></P><P>Just after that the column stopped sorting.</P><P>Here is the file example:</P></BODY></HTML> Wed, 29 Jan 2014 13:53:00 GMT https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583590#M1118167 2014-01-29T13:53:00Z Re: Issue with sorting data in zebra-chart https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583591#M1118168 <HTML><HEAD></HEAD><BODY><P>It is because you use for the background the RowNo() function, this is linked to the natural sorting of rows that can't be resorted in other ways ...</P><P>You should use other logic to obtain a zebra graph</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 29 Jan 2014 14:02:36 GMT https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583591#M1118168 alexandros17 2014-01-29T14:02:36Z Re: Issue with sorting data in zebra-chart https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583592#M1118169 <HTML><HEAD></HEAD><BODY><P><STRONG>Aleksander</STRONG></P><P></P><P>On your sort tab</P><UL><LI>Promote <EM>F1</EM> to the top of the Priority box</LI><LI>For <EM>F1</EM> select <EM>Sort by Expression, Descending</EM></LI><LI>For sort expression enter <EM>sum(F2)</EM></LI></UL><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Wed, 29 Jan 2014 14:04:58 GMT https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583592#M1118169 Anonymous 2014-01-29T14:04:58Z Re: Issue with sorting data in zebra-chart https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583593#M1118170 <HTML><HEAD></HEAD><BODY><P>Is there any suggestions about the exact way to do this?</P></BODY></HTML> Wed, 29 Jan 2014 14:05:46 GMT https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583593#M1118170 2014-01-29T14:05:46Z Re: Issue with sorting data in zebra-chart https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583594#M1118171 <HTML><HEAD></HEAD><BODY><P>Bill</P><P>I actually don't want to do it this way. Normally I have more than 1 column and I would like to have an ability to sort each of them</P></BODY></HTML> Wed, 29 Jan 2014 14:07:37 GMT https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583594#M1118171 2014-01-29T14:07:37Z Re: Issue with sorting data in zebra-chart https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583595#M1118172 <HTML><HEAD></HEAD><BODY><P>remove background color expression </P><P>goto Style tab and use "Stripes every" and/or custom format</P></BODY></HTML> Wed, 29 Jan 2014 14:07:49 GMT https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583595#M1118172 maxgro 2014-01-29T14:07:49Z Re: Issue with sorting data in zebra-chart https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583596#M1118173 <HTML><HEAD></HEAD><BODY><P>THX!</P></BODY></HTML> Wed, 29 Jan 2014 14:10:23 GMT https://community.qlik.com/t5/QlikView/Issue-with-sorting-data-in-zebra-chart/m-p/583596#M1118173 2014-01-29T14:10:23Z