topic Re: concat order by expression in QlikView

concat order by expression

Alex — Fri, 16 Nov 2018 10:10:55 GMT

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!

Re: concat order by expression

Frank_Hartmann — Fri, 16 Nov 2018 10:28:43 GMT

try this:

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

Re: concat order by expression

sasis551 — Fri, 16 Nov 2018 10:36:56 GMT

Hi ,

can you share the screenshot?

Re: concat order by expression

marcus_malinow — Fri, 16 Nov 2018 11:44:26 GMT

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

Re: concat order by expression

sunny_talwar — Fri, 16 Nov 2018 12:42:08 GMT

How do you define your Fiscal_Year_Quarter in the script?

Re: concat order by expression

Alex — Fri, 16 Nov 2018 14:58:00 GMT

It worked! Thanks!