topic Re: Sort and Slider in a straight table... in QlikView https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499817#M1133632 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>look the attachment example for Requirement(1).</P><P></P><P>Regards</P><P>Mario</P></BODY></HTML> Fri, 08 Nov 2013 15:59:43 GMT 2013-11-08T15:59:43Z Sort and Slider in a straight table... https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499816#M1133631 <HTML><HEAD></HEAD><BODY><P>Here is an requirement. I don't have DB access. I am given only the QVDs which I can't modify.</P><P>Thank you.</P></BODY></HTML> Fri, 08 Nov 2013 15:46:10 GMT https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499816#M1133631 2013-11-08T15:46:10Z Re: Sort and Slider in a straight table... https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499817#M1133632 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>look the attachment example for Requirement(1).</P><P></P><P>Regards</P><P>Mario</P></BODY></HTML> Fri, 08 Nov 2013 15:59:43 GMT https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499817#M1133632 2013-11-08T15:59:43Z Re: Re: Sort and Slider in a straight table... https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499818#M1133633 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">look the attachment example for Requirement(2).</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Mario</P></BODY></HTML> Fri, 08 Nov 2013 16:06:25 GMT https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499818#M1133633 2013-11-08T16:06:25Z Re: Sort and Slider in a straight table... https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499819#M1133634 <HTML><HEAD></HEAD><BODY><P>I tried this. I have 25 columns in the straight table of which 15 are dimensions and 10 are expression (e1, e2,..e10). AmtDue is e8-e7.</P><P>The Fabs() works good in another pivot.</P><P>Do I need to copy the fabs() to all the dimensions?</P></BODY></HTML> Fri, 08 Nov 2013 16:11:11 GMT https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499819#M1133634 2013-11-08T16:11:11Z Re: Sort and Slider in a straight table... https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499820#M1133635 <HTML><HEAD></HEAD><BODY><P>No,</P><P></P><P>you must set priority of columns of sort tab as First on one dimension with Fabs in expression.</P><P></P><P>I hope this helps</P></BODY></HTML> Fri, 08 Nov 2013 16:19:27 GMT https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499820#M1133635 2013-11-08T16:19:27Z Re: Sort and Slider in a straight table... https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499821#M1133636 <HTML><HEAD></HEAD><BODY><P>You can use an expression like fabs(sum(rangesum(ProposedAmt,-AmtCollected))) for Sort by Expression (on the Sort tab).</P><P>The same expression works as well to have the slider work correctly. See attached example.</P></BODY></HTML> Fri, 08 Nov 2013 18:18:00 GMT https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499821#M1133636 Gysbert_Wassenaar 2013-11-08T18:18:00Z Re: Sort and Slider in a straight table... https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499822#M1133637 <HTML><HEAD></HEAD><BODY><P>Thank you. This resolves my issues.</P></BODY></HTML> Fri, 08 Nov 2013 21:06:04 GMT https://community.qlik.com/t5/QlikView/Sort-and-Slider-in-a-straight-table/m-p/499822#M1133637 2013-11-08T21:06:04Z