topic Re: How sorted dates with ValueLoop between two dates? in QlikView https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162871#M378908 <HTML><HEAD></HEAD><BODY><P>Thank you, but this not good decision for me. =(&nbsp; </P></BODY></HTML> Fri, 15 Jul 2016 01:16:58 GMT warfollowmy_ver 2016-07-15T01:16:58Z How sorted dates with ValueLoop between two dates? https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162867#M378904 <HTML><HEAD></HEAD><BODY><P>Hi, all! How sorted this expression desc\asc in field input ???</P><P></P><P>=concat(Date(ValueLoop(TODAY()-1000,TODAY()-1,1),'YYYY-MM-DD'),';')</P></BODY></HTML> Fri, 15 Jul 2016 00:40:07 GMT https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162867#M378904 warfollowmy_ver 2016-07-15T00:40:07Z Re: How sorted dates with ValueLoop between two dates? https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162868#M378905 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ValueLoop</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TODAY</SPAN><SPAN style="font-size: 8pt;">()-1000,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TODAY</SPAN><SPAN style="font-size: 8pt;">()-1,1),'YYYY-MM-DD'),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(13)) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">This already shows in the ASC order.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Sorry, You want these dates to be displayed in a list box in a sorted fasion?</SPAN></P></BODY></HTML> Fri, 15 Jul 2016 00:45:22 GMT https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162868#M378905 2016-07-15T00:45:22Z Re: How sorted dates with ValueLoop between two dates? https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162869#M378906 <HTML><HEAD></HEAD><BODY><P>Need <SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 29px;">Descending from fresh to old</SPAN></P></BODY></HTML> Fri, 15 Jul 2016 01:02:12 GMT https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162869#M378906 warfollowmy_ver 2016-07-15T01:02:12Z Re: How sorted dates with ValueLoop between two dates? https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162870#M378907 <HTML><HEAD></HEAD><BODY><P>I don't think it is possible. Better of generating the values for that date field in a script and use that field with the neccessary sorting.</P></BODY></HTML> Fri, 15 Jul 2016 01:15:21 GMT https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162870#M378907 2016-07-15T01:15:21Z Re: How sorted dates with ValueLoop between two dates? https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162871#M378908 <HTML><HEAD></HEAD><BODY><P>Thank you, but this not good decision for me. =(&nbsp; </P></BODY></HTML> Fri, 15 Jul 2016 01:16:58 GMT https://community.qlik.com/t5/QlikView/How-sorted-dates-with-ValueLoop-between-two-dates/m-p/1162871#M378908 warfollowmy_ver 2016-07-15T01:16:58Z