topic Re: Is there a way to sort input box in QlikView

Is there a way to sort input box

varunreddy — Tue, 18 Aug 2015 18:30:48 GMT

Hi Guys,

I created a input box and created list of values using field called Date. I want to sort Date field.

Expression Used:

Concat(Distinct Date, ',')

I have dates in this format:

7/31/2015

8/14/2015

8/7/2015.

The format I am looking for:

7/31/2015

8/7/2015

8/14/2015

Is there any way that I can sort listed values?

Can anyone please help me.

Thanks in advance

Regards,

Varun. K

Re: Is there a way to sort input box

Nicole-Smith — Tue, 18 Aug 2015 19:16:07 GMT

Add a sort value to your concat() so that it sorts by the number instead of by text (default):

=Concat(Distinct Date, ',', Date)

Re: Is there a way to sort input box

rwunderlich — Tue, 18 Aug 2015 19:18:52 GMT

Take a look at the Help for the Concat() function. You will see that there is an optional sort weight parameter.

Concat(Distinct Date, ',', Date)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Is there a way to sort input box

rwunderlich — Tue, 18 Aug 2015 19:19:47 GMT

Nicole, I think the default sort for concat() is Load Order.

-Rob

Re: Is there a way to sort input box

Nicole-Smith — Tue, 18 Aug 2015 19:33:55 GMT

When I test it, it doesn't do it in load order for me:

LOAD * INLINE [

Date

7/31/2015

8/7/2015

8/14/2015

];

=Concat(Distinct Date, ',') returns 7/31/2015,8/14/2015,8/7/2015

So I think it is sorting it by text...

Re: Is there a way to sort input box

varunreddy — Tue, 18 Aug 2015 20:04:36 GMT

Thank You Nicole

Regards,

Varun. K

Re: Is there a way to sort input box

varunreddy — Tue, 18 Aug 2015 20:04:50 GMT

Thank You Nicole

Regards,

Varun. K

Re: Is there a way to sort input box

varunreddy — Tue, 18 Aug 2015 20:05:26 GMT

Thank You Rob

Regards,

Varun. K