Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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...Smiley Sad

See the screenshot for more details of the error.

graph.PNG

Anyone can help me please...

Gino.

1 Solution

Accepted Solutions
Not applicable

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

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!

3 Replies

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

Could you please provide your source document?

Not applicable

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

I don't have any qvd now...

Not applicable

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

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!

Community Browser