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]

Upload a sample file.

It is possible depending on your expression and what you are asking based on your dataset. Only way to confirm is to make available a data sample and your expression in the chart

Cheers,

Byron

[#3]

Here is the .qvw

I only have a Personal Edition, so if you could just tell me what to do I would be happy

Greetings,

Lucas

[#4]

What fields are selecting that is resulting in the 1.0 being populated throughout the chart?

And yes, I will tell you what it is that I did to figure it out once I do

Cheers,

Byron

[#5]

Just "Priorität" and maybe Location, I'm not 100% sure.

Greetings,

Lucas

[Anonymous]

Lucas

You have the field Data in both you fact table which becomes part of the synthetic key along with Monat that joins them.

How about renaming the Data field in one of your table to remove this filed being part of the join.  This wiill also remove the synthetic key.

Best Regards,     Bill

[#7]

Hi,

This kinda works, but then I have to make 2 separate charts. One for Data1 and one for Data2.

Greetings,

Lucas

[#8]

Hi Lucas,

Try concatenating both the tables.

Hope this helps!

--

Vinoth

[#9]

Doesn't look like Concatenate() works with Crosstables, but thanks anyway for the reply!

Greetings,

Lucas

[sudeepkm]

May be you concatenate at first on the raw data from the files then do a cross table on the table using resident load.

The script would be something like below.

//Store data from two files in to dat table, since the fields are same it will be auto concatenate

dat:

LOAD id,

     data,

     JAN,

     FEB,

     MAR

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD id,

     data,

     JAN,

     FEB,

     MAR

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

// create cross table by doing resident load

crsdat:

CrossTable(mon, mondat, 2)

LOAD id,

     data,

     JAN,

     FEB,

     MAR

Resident dat;

// drop the main table

drop Table dat;