Is there a way to sort input box

[varunreddy]

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

[Nicole-Smith]

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

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

[rwunderlich]

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

[rwunderlich]

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

-Rob

[Nicole-Smith]

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...

[varunreddy]

Thank You Nicole

Regards,

Varun. K

[varunreddy]

Thank You Nicole

Regards,

Varun. K

[varunreddy]

Thank You Rob

Regards,

Varun. K