Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SetAnalysis not Work for second expression in chart

Hi Guys,

i have a problem with setAnalysis in line chart:

my dimension is =left(YYYYMM,4)&'-'&right(YYYYMM,2)

and my expression are:

1. sum({<MonthYearX=>}sales1)

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

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

if I select MonthYearX for the first expression the chart don't change, but not work when i add the others expression. The others sales i didn't have data for all time only for a portion.

My sort expression is:

chr(left(YYYYMM,4)&'-'&right(YYYYMM,2)) with TEXT A->Z checked, if i don't do this the chart does not working either for the first expression.

1 Solution

Accepted Solutions
Not applicable
Author

I solved:

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

and Qlik have probelm 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!

View solution in original post

1 Reply
Not applicable
Author

I solved:

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

and Qlik have probelm 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!