Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
Could you please provide your source document?
I don't have any qvd now...
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!