topic Re: expression sort consistent in QlikView https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380870#M420905 <HTML><HEAD></HEAD><BODY><P>it is close to 10 in May too though. I will post a sample as soon as I can. Have to clear out all the irrelevant stuff first...</P></BODY></HTML> Fri, 08 Sep 2017 18:14:29 GMT Margaret 2017-09-08T18:14:29Z expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380867#M420902 <HTML><HEAD></HEAD><BODY><P>How can I make the colors in a stacked bar chart always appear in the same order (across dimension values)? See in image how green "Order to Collection" section sometimes appears in one month second from top, in another month last (4th from top).</P><P></P><P><IMG alt="StackedBarSortConsistent.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175979_StackedBarSortConsistent.PNG" style="height: 227px; width: 620px;" /></P></BODY></HTML> Fri, 08 Sep 2017 16:13:59 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380867#M420902 Margaret 2017-09-08T16:13:59Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380868#M420903 <HTML><HEAD></HEAD><BODY><P>Can you share a sample.? May be your June 2017 sum value is less than 10 so it is plotting the color near that axis. </P></BODY></HTML> Fri, 08 Sep 2017 17:00:11 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380868#M420903 vishsaggi 2017-09-08T17:00:11Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380869#M420904 <HTML><HEAD></HEAD><BODY><P>I made some tests and I can't get the same result, the expressions are always sorted in the same order.</P><P></P><P>Can you post a sample to check?</P></BODY></HTML> Fri, 08 Sep 2017 17:15:55 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380869#M420904 rubenmarin 2017-09-08T17:15:55Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380870#M420905 <HTML><HEAD></HEAD><BODY><P>it is close to 10 in May too though. I will post a sample as soon as I can. Have to clear out all the irrelevant stuff first...</P></BODY></HTML> Fri, 08 Sep 2017 18:14:29 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380870#M420905 Margaret 2017-09-08T18:14:29Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380871#M420906 <HTML><HEAD></HEAD><BODY><P>see attached.</P></BODY></HTML> Fri, 08 Sep 2017 18:51:42 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380871#M420906 Margaret 2017-09-08T18:51:42Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380872#M420907 <HTML><HEAD></HEAD><BODY><P>Your OrderTocollection for Month June-2017 shows -1 ? This could be the reason. </P></BODY></HTML> Fri, 08 Sep 2017 20:23:23 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380872#M420907 vishsaggi 2017-09-08T20:23:23Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380873#M420908 <HTML><HEAD></HEAD><BODY><P>May be you can try like?</P><P></P><P>= Fabs(Median(Ord_Coll_Mins))</P></BODY></HTML> Fri, 08 Sep 2017 20:59:12 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380873#M420908 vishsaggi 2017-09-08T20:59:12Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380874#M420909 <HTML><HEAD></HEAD><BODY><P>You're right. It's the "-1". But its supposed to be "-1", not "1". (We have some psychics around here.)</P><P></P><P>Thank you.</P><P></P><P>So I need to figure out how to ignore negative numbers..... or turn any negative number into a zero...?</P></BODY></HTML> Fri, 08 Sep 2017 21:27:25 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380874#M420909 Margaret 2017-09-08T21:27:25Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380875#M420910 <HTML><HEAD></HEAD><BODY><P>Or maybe I'll just explain to end users what they are looking at... It does a pretty job of illustrating what's going on.</P><P></P><P>The only better option would be to Collection to Receive time overlap with Arrival to Order time by one minute.</P></BODY></HTML> Fri, 08 Sep 2017 21:31:32 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380875#M420910 Margaret 2017-09-08T21:31:32Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380876#M420911 <HTML><HEAD></HEAD><BODY><P>‌oh Ok you can turn negative values to 0 using if like </P><P>= If (median(Ord_Coll_mins) &lt; 0, 0, median(ord_coll_mins))</P></BODY></HTML> Fri, 08 Sep 2017 22:39:40 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380876#M420911 vishsaggi 2017-09-08T22:39:40Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380877#M420912 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Another option can be:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RangeMax(Median(Ord_Coll_Mins), 0)</P></BODY></HTML> Sun, 10 Sep 2017 10:10:49 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380877#M420912 rubenmarin 2017-09-10T10:10:49Z Re: expression sort consistent https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380878#M420913 <HTML><HEAD></HEAD><BODY><P>In Colors tab you can select persistent check box so that the color will be constant even after the selection.</P></BODY></HTML> Sun, 10 Sep 2017 16:25:14 GMT https://community.qlik.com/t5/QlikView/expression-sort-consistent/m-p/1380878#M420913 svinnakota 2017-09-10T16:25:14Z