topic Bad data association in QlikView

Bad data association

Thu, 07 Nov 2013 15:12:04 GMT

Hi everybody,

I'd need a little help understanding why my qlikview application makes bad data association.

I attached 2 previews of how the data changes at different clicks.

I cannot understand why when i select the month/quarter for which i want to see the data, it changes.

I assume it's kind of a big problem, so please help!

Thanks a lot!

Re: Bad data association

sivarajs — Thu, 07 Nov 2013 15:39:32 GMT

Excels are like cross table. If you load in normal way to click view, it will consider as individual column. You need to do cross table transformation

Check whether you done the following steps while loading

Refer this link Cross Table in QlikView | Learn QlikView

Else post your sample

Re: Bad data association

Anonymous — Thu, 07 Nov 2013 16:48:15 GMT

Can you upload your application? And, explain what is the expected functionality?

Re: Bad data association

Thu, 07 Nov 2013 16:49:17 GMT

It would be easier if you could post an example of your QVW, I could take a look at the schema then.

Re: Bad data association

Fri, 08 Nov 2013 09:12:03 GMT

Hi there,

Here's a simplified version of my app.

Hope you can figure out why it makes this bad associations.

Thanks a lot for the help!

Re: Bad data association

Anonymous — Fri, 08 Nov 2013 13:50:49 GMT

Can you make it smaller? Maybe 1MB or less?

Re: Re: Bad data association

Fri, 08 Nov 2013 14:35:20 GMT

I don't think i can make it smaller

Hope this helps.

Thanks!

Re: Bad data association

Anonymous — Fri, 08 Nov 2013 15:21:24 GMT

You can.

Make some selections, go to File - Reduce Data - Keep possible values. Save under a different name. Just make sure that after you reduce it you still can reproduce the problem.

BTW, I tried to open your 20.7 MB file, and got error "the document ... failed to load"

Re: Bad data association

Fri, 08 Nov 2013 15:43:12 GMT

There's a problem.

When i reduce data with keep possible values, the data in the table changes.

And afterwards, the problem i had at first is no longer there. What i mean: after i reduce the data, when i click on a month it keeps the right value (to be clearer, the new value, but it seem to make the right associations).

Do you have any idea why the data in the table changes when i choose "reduce data"?

Re: Bad data association

Anonymous — Fri, 08 Nov 2013 16:20:46 GMT

Sorry, can't guess what's going on without an example. In general, data supposed to change when selections are made. So, in addition to a working file, need explanation - where you click, what you see, and what you expect to see.

Regards,

Michael