topic Sorting in Expressions using &quot;Sort by Expression&quot; in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240747#M504029 <HTML><HEAD></HEAD><BODY><P>I also notice in help that what I am trying to do may not work...</P><P>From help...</P><P class="hcp5"><STRONG>Expression</STRONG><BR />Sorts the column values according to the expression entered into the text edit box below this sort option. This option is not available for calculated dimensions.</P><P class="hcp5"></P><P class="hcp5">Any workaround?</P></BODY></HTML> Wed, 17 Feb 2010 19:10:04 GMT 2010-02-17T19:10:04Z Sorting in Expressions using "Sort by Expression" in Straight Table https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240746#M504028 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Long time lerker here and I have search everywhere but couldn't find the solution for this.</P><P>This is what I have (in 8.5)</P><P>A straight table with 1 dimension and 4 expressions</P><P>Dimension<BR />Username</P><P>Expression<BR />Exp1 = SEP<BR />Exp2 = OCT<BR />Exp3 = NOV<BR />Exp4 = DEC</P><P>I am using "Username" as a dimention (group by) then sum Exp1/2/3/4 in Expressions using Sum(Exp1) and so forth...</P><P>Here's what the table looks like</P><P>Username SEP OCT NOV DEC<BR />John 100 200 300 400<BR />Smith 9 900 30 99<BR />Jim -80 100 -88 -70</P><P>I would like to be able to sort by absolute value (FABS) when clicking on SEP, OCT, NOV and DEC.<BR /><BR />I have tried using this, FABS(SUM(EXP1)), which doesn't work and I saw that you can't sort via expression when summing the field.</P><P>Is there a work around for this?</P><P></P><P>Please help!</P><P></P></BODY></HTML> Wed, 17 Feb 2010 19:06:53 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240746#M504028 2010-02-17T19:06:53Z Sorting in Expressions using "Sort by Expression" in Pivot table https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240747#M504029 <HTML><HEAD></HEAD><BODY><P>I also notice in help that what I am trying to do may not work...</P><P>From help...</P><P class="hcp5"><STRONG>Expression</STRONG><BR />Sorts the column values according to the expression entered into the text edit box below this sort option. This option is not available for calculated dimensions.</P><P class="hcp5"></P><P class="hcp5">Any workaround?</P></BODY></HTML> Wed, 17 Feb 2010 19:10:04 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240747#M504029 2010-02-17T19:10:04Z Sorting in Expressions using "Sort by Expression" in Pivot table https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240748#M504030 <HTML><HEAD></HEAD><BODY><P>Thanks for your question... it solved my problem... <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P><P>You can actually sort using the same exact expression but simply placing it on a non-calculated dimension.</P><P></P><P>Thanks,</P><P>Rocky</P></BODY></HTML> Fri, 19 Feb 2010 17:10:50 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240748#M504030 boorgura 2010-02-19T17:10:50Z Sorting in Expressions using "Sort by Expression" in Pivot table https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240749#M504031 <HTML><HEAD></HEAD><BODY><P>I don't understand. Can you please explain?</P></BODY></HTML> Fri, 19 Feb 2010 17:36:56 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Expressions-using-quot-Sort-by-Expression-quot-in/m-p/240749#M504031 2010-02-19T17:36:56Z