topic Re: Ordering by dimension1 into dimension2 in QlikView https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388566#M145012 <HTML><HEAD></HEAD><BODY><P>Sorry I did not understand your point but, with the exemple attached, now is clair, it works.</P><P></P><P>Now I will have to investigate how not to loose the order by TTOO, after adding a dimension YEAR in columns (2010,2011,2012,TOTAL), if you know how to get so...</P><P></P><P>Thank you</P></BODY></HTML> Wed, 31 Oct 2012 17:37:58 GMT 2012-10-31T17:37:58Z Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388558#M145004 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a pivot table whith two row dimensions. Let assume that dimension1 is included in dimension2 so all dimension1 values appear once for each value of dimension2.</P><P></P><P>If I order dimension1 by one of the expresions it does not appears correctly ordered, only if I remove dimension2 the list is correctly oredered, but I need to order the dimension1 values into each dimension2 values.</P><P></P><P>What additional command I need?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 31 Oct 2012 11:38:21 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388558#M145004 2012-10-31T11:38:21Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388559#M145005 <HTML><HEAD></HEAD><BODY><P>Using the same order in both dimensions? Could you specify wich is that order??</P></BODY></HTML> Wed, 31 Oct 2012 12:23:08 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388559#M145005 chematos 2012-10-31T12:23:08Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388560#M145006 <HTML><HEAD></HEAD><BODY><P>Like in the excel attached, TTOO is a dimension1 and HOTEL_ABREVIA is dimension2 I want the 'Prod.' of each TTOO from the bigger to the smaller for each value of HOTEL_ABREVIA. No matter if HOTEL_ABREVIA is ordered alfabetically or by total 'Prod.' the important thing is the order into each HOTEL_ABREVIA value.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 31 Oct 2012 12:33:41 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388560#M145006 2012-10-31T12:33:41Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388561#M145007 <HTML><HEAD></HEAD><BODY><P>I thought I already did that for you. See attached qvw. It's sorted by ascending text on Hotel_abrevia and then on Prod by descending numeric value. See the Sort tab of the properties screen.</P></BODY></HTML> Wed, 31 Oct 2012 12:41:31 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388561#M145007 Gysbert_Wassenaar 2012-10-31T12:41:31Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388562#M145008 <HTML><HEAD></HEAD><BODY><P>Your attached was usefull to learn the use of 'Total&lt;&gt;' but your object is a simple table and I am working a pivot table, it orders correctly when I have only one dimension in rows but I need to have several dimensions.</P><P>Regards</P></BODY></HTML> Wed, 31 Oct 2012 12:51:45 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388562#M145008 2012-10-31T12:51:45Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388563#M145009 <HTML><HEAD></HEAD><BODY><P>If you don´t need to order Dimension 1 in alphabetic order, use Value Y descending in Dimension1 order</P></BODY></HTML> Wed, 31 Oct 2012 12:58:02 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388563#M145009 chematos 2012-10-31T12:58:02Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388564#M145010 <HTML><HEAD></HEAD><BODY><P>I don't need to order TTOO alphabetically just by the expresion 'Prod', is easy to get so without its dimension 'mother' HOTEL_ABREVIA as a row dimension.</P><P></P><P>Thanks you all any way</P></BODY></HTML> Wed, 31 Oct 2012 15:48:05 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388564#M145010 2012-10-31T15:48:05Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388565#M145011 <HTML><HEAD></HEAD><BODY><P>I think I´m missunderstanding something, this is not what you wanted? </P></BODY></HTML> Wed, 31 Oct 2012 16:15:23 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388565#M145011 chematos 2012-10-31T16:15:23Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388566#M145012 <HTML><HEAD></HEAD><BODY><P>Sorry I did not understand your point but, with the exemple attached, now is clair, it works.</P><P></P><P>Now I will have to investigate how not to loose the order by TTOO, after adding a dimension YEAR in columns (2010,2011,2012,TOTAL), if you know how to get so...</P><P></P><P>Thank you</P></BODY></HTML> Wed, 31 Oct 2012 17:37:58 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388566#M145012 2012-10-31T17:37:58Z Re: Ordering by dimension1 into dimension2 https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388567#M145013 <HTML><HEAD></HEAD><BODY><P>You're welcome, I should try a little more, for each dimension, more complex... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/mischief.png" /></P><P></P><P>Regards</P></BODY></HTML> Wed, 31 Oct 2012 18:01:20 GMT https://community.qlik.com/t5/QlikView/Ordering-by-dimension1-into-dimension2/m-p/388567#M145013 chematos 2012-10-31T18:01:20Z