Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Similar tables disturb charts

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":

LOAD * INLINE [

    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.,,)

Tags (1)
2 Replies
Employee
Employee

Re: Similar tables disturb charts

Try renaming your fields

"Age Groups Germany":

LOAD * INLINE [

    Age, "Total Population by Age", "Mobile User (Unique User) By Age"

    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

];

"Sex Germany":

LOAD * INLINE [

    Sex, "Total Population By Sex", "Mobile User (Unique User) by Sex"

    Male, 48.9, 58.7

    Female, 51.1, 41.3

];

blackmon
New Contributor III

Re: Similar tables disturb charts

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.


Community Browser