topic Re: sort in straight table in QlikView https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677281#M1084892 <HTML><HEAD></HEAD><BODY><P>Hi Adi,</P><P></P><P>this is my option. Please see picture below:</P><P></P><P><IMG alt="TaskSort.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61405_TaskSort.jpg" style="width: 620px; height: 392px;" /></P><P>Hope this helps</P><P></P><P>Burkhard</P></BODY></HTML> Mon, 30 Jun 2014 06:51:26 GMT veidlburkhard 2014-06-30T06:51:26Z sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677279#M1084890 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i have the next table IN MY SCHEME:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>project</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>task</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>task sort</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">ADS</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">ASDFSA</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">ASD</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">BFA</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">CASDA</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">CSAFE</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">DVB</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">DFGRE</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE><P></P><P>I have a straight table fir column project second column task and expressions...</P><P></P><P>i want that the project will sort abc... and in the project the task sort by 'task sort'</P><P></P><P>in the sort tab i put the project by abc and task by expression 'task sort'</P><P></P><P>the firs project is sorted but the rest are not</P><P></P><P>someone know why??</P><P></P><P>adi</P></BODY></HTML> Mon, 30 Jun 2014 06:41:35 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677279#M1084890 adiarnon 2014-06-30T06:41:35Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677280#M1084891 <HTML><HEAD></HEAD><BODY><P>please find attached. just right click on the second column and say sort.</P></BODY></HTML> Mon, 30 Jun 2014 06:45:23 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677280#M1084891 2014-06-30T06:45:23Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677281#M1084892 <HTML><HEAD></HEAD><BODY><P>Hi Adi,</P><P></P><P>this is my option. Please see picture below:</P><P></P><P><IMG alt="TaskSort.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61405_TaskSort.jpg" style="width: 620px; height: 392px;" /></P><P>Hope this helps</P><P></P><P>Burkhard</P></BODY></HTML> Mon, 30 Jun 2014 06:51:26 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677281#M1084892 veidlburkhard 2014-06-30T06:51:26Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677282#M1084893 <HTML><HEAD></HEAD><BODY><P>its not working.</P><P>in my table there is no column of the sort,,,</P></BODY></HTML> Mon, 30 Jun 2014 07:01:43 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677282#M1084893 adiarnon 2014-06-30T07:01:43Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677283#M1084894 <HTML><HEAD></HEAD><BODY><P>But, Adi, I used your table from above. I mean the column 'task sort' is taken from your table ?!?</P></BODY></HTML> Mon, 30 Jun 2014 07:05:41 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677283#M1084894 veidlburkhard 2014-06-30T07:05:41Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677284#M1084895 <HTML><HEAD></HEAD><BODY><P> in the sceme there is that column but not in the straight table...</P><P></P><P>hope its clear...</P></BODY></HTML> Mon, 30 Jun 2014 07:11:45 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677284#M1084895 adiarnon 2014-06-30T07:11:45Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677285#M1084896 <HTML><HEAD></HEAD><BODY><P>So, if you have the dimension 'task sort' in your qvw, all is fine. You only need the expression 'only([task sort])' for the sorting of the 'task' column. No need of a column 'task sort'.</P></BODY></HTML> Mon, 30 Jun 2014 07:22:14 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677285#M1084896 veidlburkhard 2014-06-30T07:22:14Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677286#M1084897 <HTML><HEAD></HEAD><BODY><P>i try, bur its not working</P></BODY></HTML> Mon, 30 Jun 2014 07:23:55 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677286#M1084897 adiarnon 2014-06-30T07:23:55Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677287#M1084898 <HTML><HEAD></HEAD><BODY><P>use the match() function in SORT tab, expression&nbsp; Match(task,'ASDFSA','ADS','ASD')</P></BODY></HTML> Mon, 30 Jun 2014 08:24:51 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677287#M1084898 PradeepReddy 2014-06-30T08:24:51Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677288#M1084900 <HTML><HEAD></HEAD><BODY><P>this data is just an exemple... i dont understand your solution</P></BODY></HTML> Mon, 30 Jun 2014 08:30:37 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677288#M1084900 adiarnon 2014-06-30T08:30:37Z Re: sort in straight table https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677289#M1084902 <HTML><HEAD></HEAD><BODY><P>can u provide the sample data and expected output? so that it will be easy to figure out the solution...</P></BODY></HTML> Mon, 30 Jun 2014 09:12:48 GMT https://community.qlik.com/t5/QlikView/sort-in-straight-table/m-p/677289#M1084902 PradeepReddy 2014-06-30T09:12:48Z