Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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!