Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The problem I have is following:
When my script only the following code has...:
"Age Groups Germany":
LOAD * INLINE [
Age, "Total Population", "Mobile User (Unique User)"
14-19, 7.1, 13.3
20-29, 14.0, 27.7
30-39, 13.8, 21.4
40-49, 19.0, 21.7
50-59, 16.4, 10.0
60+, 29.6, 5.8
];
... then everything is ok. I can generate my chart the way I want.
However, when I add to the script the following code:
"Sex Germany":
Sex, "Total Population", "Mobile User (Unique User)"
Male, 48.9, 58.7
Female, 51.1, 41.3
the diagram that is based on the first table gets messed up.
Why is that happening and how can I avoid it?
(I already tried some combinations with QUALIFY and NOCONCATENATE... did not work as I wanted it.,,)
Try renaming your fields
Age, "Total Population by Age", "Mobile User (Unique User) By Age"
Sex, "Total Population By Sex", "Mobile User (Unique User) by Sex"
Rename the Total Population field to something unique, unless you mean to have them associated.
Rename the "Mobile User (Unique User)" to something unique also.
