topic Sort order in line chart change with set Analysys why?!?!?!? in QlikView

Sort order in line chart change with set Analysys why?!?!?!?

Thu, 21 Feb 2013 11:52:55 GMT

Hi everyone,

I have a problem with setAnalysis in line chart:

my dimension is YYYYMM

and my expression are:

1. sum({<MonthYearX=>}field1) MonthYearX=YYYMM+X where X is a number of month in the past or in the future

2. sum({<MonthYearX=>}field2)

3. sum({<MonthYearX=>}field3)

I sort my chart for expression: =YYYYMM but when i select one MonthYearX the chart order put this MonthYearX at the top of chart order of X-Axes.

Why??? I must keep locked my sort order...:(

See the screenshot for more details of the error.

Anyone can help me please...

Gino.

alexandros17 — Thu, 21 Feb 2013 12:10:10 GMT

Could you please provide your source document?

Thu, 21 Feb 2013 12:26:30 GMT

I don't have any qvd now...

Wed, 27 Feb 2013 15:45:10 GMT

I solved:

MI Dimension is left(YYYYMM,4)&'-'&right(YYYYMM,2))...

and Qlik have problm in sort because data types not clear. If I declare dimension with this:

text(left(YYYYMM,4)&'-'&right(YYYYMM,2)) and sort with text field all is OK!