topic Re: Calendar error in QlikView

Calendar error

shanky1907 — Mon, 25 May 2015 15:36:26 GMT

Hello,

I have an issue with the application as there is a cross table expression from that date field(Not a proper date field, just for time representation) is taken.

the format of date field is like this

201501

201502

201503...12

2016Q1

2016Q2...Q4

2017

2018

2019

On this filed, i need to sort a chart in ascending order of time. But i cant as it is not showing proper date stmap.

Please help finding any solution.

Thanks in advance.

Re: Calendar error

Clever_Anjos — Mon, 25 May 2015 15:40:28 GMT

Text Order will handle proper sorting

Re: Calendar error

shanky1907 — Mon, 25 May 2015 16:19:19 GMT

I tried Text Order Sorting. But its also not giving correct order.

Re: Calendar error

Clever_Anjos — Mon, 25 May 2015 16:33:15 GMT

Would you mind sharing your app? Preparing examples for Upload - Reduction and Data Scrambling

Re: Calendar error

maxgro — Mon, 25 May 2015 17:55:21 GMT

load

dual(field,

if(len(field)=4, date(MakeDate(field)),

if(isnum(field), date(MakeDate(Left(field,4), num(Right(field,2)))),

MakeDate(Left(field,4), div(Right(field,1),3)+1

)))) as field

inline [

field

2016Q1

2016Q2

2016Q3

2016Q4

2019

201501

201502

201503

201504

201505

201506

201507

201508

201509

201510

201511

201512

2017

2018

];

Re: Calendar error

shanky1907 — Tue, 26 May 2015 08:27:44 GMT

Thanks for the explanation massimo.

I have tried 'Match' in the expression for sorting and got the right order for all the values as required.

Exp:

=Match (expr, vlaue1, value2,......value10)

Here,

Value1 will be given index# 1, value2 will be given index# 2 and so on.

So, by keeping this expression in ascending order had worked for me.