topic Re: Sort Data in QlikView

topic Re: Sort Data in QlikView https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415822#M570518 <HTML><HEAD></HEAD><BODY><P>i think this expression in sort tab should sort the values but if you have a selection then all tha associated data will be sorted and unassociated data won't be sorted..</P><P></P><P>if you want unassocaited data to be sorted then this expression has to be in script and you have to use orderby clause</P><P></P><P>Hope this helps</P><P>thanks</P></BODY></HTML> Mon, 15 Oct 2012 15:49:03 GMT Anonymous 2012-10-15T15:49:03Z Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415817#M570513 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I have dimension below ISTEK_ACISTARIHI2 date format and its format dd.mm.yyyy hh:mm:ss</P><P>I want to sort data according to below expression </P><P></P><P>=day(weekstart(ISTEK_ACISTARIHI2))&' ' &monthname(weekstart(ISTEK_ACISTARIHI2))&'-' & day(weekend(ISTEK_ACISTARIHI2)) &' ' & monthname(weekend(ISTEK_ACISTARIHI2))</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 15 Oct 2012 14:28:47 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415817#M570513 QSense 2012-10-15T14:28:47Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415818#M570514 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I know sort tab but It doesnt be sorted correctly </P></BODY></HTML> Mon, 15 Oct 2012 14:50:43 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415818#M570514 QSense 2012-10-15T14:50:43Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415819#M570515 <HTML><HEAD></HEAD><BODY><P>Why don'y you sort based on a numerical value of NUM(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">day(weekstart(ISTEK_ACISTARIHI2))&' ' &monthname(weekstart(ISTEK_ACISTARIHI2))&Year(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">monthname(weekstart(ISTEK_ACISTARIHI2))</SPAN>))</SPAN></P><P></P><P> That should give you the result your seeking remember you only really ned to sort by the first date since the rest will follow suit naturally.</P></BODY></HTML> Mon, 15 Oct 2012 15:42:38 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415819#M570515 2012-10-15T15:42:38Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415820#M570516 <HTML><HEAD></HEAD><BODY><P>i think this expression in sort tab should sort the values but if you have a selection then all tha associated data will be sorted and unassociated data won't be sorted..</P><P></P><P>if you want unassocaited data to be sorted then this expression has to be in script and you have to use orderby clause</P><P></P><P>Hope this helps</P><P>thanks</P></BODY></HTML> Mon, 15 Oct 2012 15:48:50 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415820#M570516 Anonymous 2012-10-15T15:48:50Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415821#M570517 <HTML><HEAD></HEAD><BODY><P>i think this expression in sort tab should sort the values but if you have a selection then all tha associated data will be sorted and unassociated data won't be sorted..</P><P></P><P>if you want unassocaited data to be sorted then this expression has to be in script and you have to use orderby clause</P><P></P><P>Hope this helps</P><P>thanks</P></BODY></HTML> Mon, 15 Oct 2012 15:48:57 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415821#M570517 Anonymous 2012-10-15T15:48:57Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415822#M570518 <HTML><HEAD></HEAD><BODY><P>i think this expression in sort tab should sort the values but if you have a selection then all tha associated data will be sorted and unassociated data won't be sorted..</P><P></P><P>if you want unassocaited data to be sorted then this expression has to be in script and you have to use orderby clause</P><P></P><P>Hope this helps</P><P>thanks</P></BODY></HTML> Mon, 15 Oct 2012 15:49:03 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415822#M570518 Anonymous 2012-10-15T15:49:03Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415823#M570519 <HTML><HEAD></HEAD><BODY><P>i think this expression in sort tab should sort the values but if you have a selection then all tha associated data will be sorted and unassociated data won't be sorted..</P><P></P><P>if you want unassocaited data to be sorted then this expression has to be in script and you have to use orderby clause</P></BODY></HTML> Mon, 15 Oct 2012 15:49:13 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415823#M570519 Anonymous 2012-10-15T15:49:13Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415824#M570520 <HTML><HEAD></HEAD><BODY><P>i think this expression in sort tab should sort the values but if you have a selection then all the associated data will be sorted and unassociated data won't be sorted..</P><P></P><P>if you want unassocaited data to be sorted then this expression has to be in script and you have to use orderby clause</P></BODY></HTML> Mon, 15 Oct 2012 15:49:34 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415824#M570520 Anonymous 2012-10-15T15:49:34Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415825#M570521 <HTML><HEAD></HEAD><BODY><P>i think this expression in sort tab should sort the values but if you have a selection then all the associated data will be sorted and unassociated data won't be sorted..</P><P></P><P>if you want unassocaited data to be sorted then this expression has to be in script and you have to use orderby clause</P></BODY></HTML> Mon, 15 Oct 2012 15:50:02 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415825#M570521 Anonymous 2012-10-15T15:50:02Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415826#M570522 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>I attached simple file ,</P><P>and I pointed table that wanna sort  with red circle </P></BODY></HTML> Mon, 15 Oct 2012 16:30:19 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415826#M570522 QSense 2012-10-15T16:30:19Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415827#M570523 <HTML><HEAD></HEAD><BODY><P>Ok, I see the problem. Your calculated dimension is creating a string. That can only be sorted alphabetically which is not what you want. I think you need to split that in two calculated dimensions.</P><P>Start week: =date(WeekStart(ISTEK_ACISTARIHI2),'DD MMM YYYY') </P><P>End week: =date(WeekEnd(ISTEK_ACISTARIHI2),'DD MMM YYYY') </P><P>After that you can sort Start week (and End week) by Numeric Value</P></BODY></HTML> Mon, 15 Oct 2012 17:07:58 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415827#M570523 Gysbert_Wassenaar 2012-10-15T17:07:58Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415828#M570524 <HTML><HEAD></HEAD><BODY><P>Thank you man</P><P>It is ok</P></BODY></HTML> Mon, 15 Oct 2012 17:20:59 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415828#M570524 QSense 2012-10-15T17:20:59Z Re: Sort Data https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415829#M570525 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P>May ı ask something else?</P><P>Itis ok but in pivot table how to hide the colum you said ?</P><P>İn straight table I can hide .</P></BODY></HTML> Mon, 15 Oct 2012 18:02:17 GMT https://community.qlik.com/t5/QlikView/Sort-Data/m-p/415829#M570525 QSense 2012-10-15T18:02:17Z