topic Re: Chart reacting wrong to certain selection in QlikView

Chart reacting wrong to certain selection

Wed, 05 Mar 2014 13:46:56 GMT

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.

Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 13:50:29 GMT

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

Re: Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 13:59:01 GMT

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

Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 14:05:35 GMT

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

Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 14:09:29 GMT

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

Greetings,

Lucas

Re: Chart reacting wrong to certain selection

Anonymous — Wed, 05 Mar 2014 14:12:14 GMT

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

Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 14:15:25 GMT

Hi,

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

Greetings,

Lucas

Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 14:23:08 GMT

Hi Lucas,

Try concatenating both the tables.

Hope this helps!

Vinoth

Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 14:49:24 GMT

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

Greetings,

Lucas

Re: Chart reacting wrong to certain selection

sudeepkm — Wed, 05 Mar 2014 15:01:27 GMT

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;

Re: Chart reacting wrong to certain selection

Wed, 05 Mar 2014 15:18:38 GMT

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

Re: Chart reacting wrong to certain selection

Thu, 06 Mar 2014 07:03:18 GMT

Hi Lucas,

Concatenate doesn't work directly with Crosstables.

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

Vinoth

Re: Chart reacting wrong to certain selection

Mon, 10 Mar 2014 08:28:23 GMT

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