Chart reacting wrong to certain selection

[#1]

Hi,

I've been using QlikView for a few weeks now, and I've never had this problem: The chart just gives me 1.0 as a result after selecting data from a certain field, for every dimension part. Could it be that it stands for "true"?

Greetings,

Lucas

PS: I imported my data as a Crosstable, and the possible selections from one field is 1, 2, 3 and 4, the other field a certain location.

[#2]

With concatenate it gives me a script error and without it doesn't work at all... Thanks for the help though! I'll be gone until next Monday, so I can check then again.

Greetings,

Lucas

[#3]

Hi Lucas,

Concatenate doesn't work directly with Crosstables.

You need to take the resident of both the tables and then try concatenating.

--

Vinoth

[#4 · Accepted solution]

Well I've been trying a few things, and I tried joining the two tables first, and then making a Crosstable out of the (now one) joined tables, and ta-daa, it worked! I still had to manually define the LOAD order, but that was all!

Thanks for your help,

Lucas