concat order by expression

[Alex]

Hi all,

I would like to order by year & quarter desc (Q1-FY19,Q4-FY18,etc.)

concat(distinct chr(39) & Fiscal_Year_Quarter & chr(39), ',',????)

In all my charts I order by expression Num(Year&Replace(Quarter,'Q','')) but it doesn't work here. Any idea?

Thanks!

[Frank_Hartmann · Accepted solution]

try this:

concat(distinct chr(39) & Fiscal_Year_Quarter & chr(39), ',',num(right(Fiscal_Year_Quarter,2)&left(purgechar(Fiscal_Year_Quarter,'Q'),1)))

[sasis551]

Hi ,

can you share the screenshot?

[marcus_malinow]

Another approach would be to set up your Fiscal_Year_Quarter field as a dual in your load script. Then you don't need to fiddle around with custom sort orders in your expressions.

https://community.qlik.com/t5/QlikView-Documents/How-to-use-Dual/ta-p/1477054

[sunny_talwar]

How do you define your Fiscal_Year_Quarter in the script?

[Alex]

It worked! Thanks!