topic Re: Sort months in string in QlikView

Sort months in string

Wed, 22 Oct 2014 10:27:06 GMT

Hi guys,

I am using text box to show curremt selection:

='>> ' &

Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(date([DB Date]), ', ')

so in result I will have >>year>quarter>month

the problem is that if I will select more than 1 month it will sort months alfabeticaly.

Is there any way to stop sorting?

Thank you,

Andrzej

rubenmarin — Wed, 22 Oct 2014 10:35:47 GMT

Hi, maybe:

='>> ' &

Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(date([DB Date]), ', ', date([DB Date]))

If not, can you post a sample of the data to make tests?

its_anandrjs — Wed, 22 Oct 2014 10:38:01 GMT

In text i don't believe you sort it but you can use the straight table for this with only expression.

Regards,

Anand

Wed, 22 Oct 2014 10:39:50 GMT

I am sorry I add wrong formula in OP

the formula from OP works fine as it has full date. but i want to show months only, and then it sorts incorrectly:

='>> ' &

Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(month([DB Date]), ',')

MarcoWedel — Wed, 22 Oct 2014 10:45:49 GMT

please post sample data/app

tresB — Wed, 22 Oct 2014 10:45:52 GMT

If you want the like: Jan, Feb, Mar.. then try like:

concat(Distinct month([DB Date]), ',', month([DB Date]))

the second 'month([DB Date])' defines the sort order.

Wed, 22 Oct 2014 11:02:37 GMT

Thanks, this is what I needed. It works after little adjustment

concat(month([DB Date]), ', ',date([DB Date]))