Bad data association

[#1]

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!

[sivarajs]

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

[Anonymous]

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

[#4]

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

[#5]

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!

[Anonymous]

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

[#7]

I don't think i can make it smaller

Hope this helps.

Thanks!

[Anonymous]

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"

[#9]

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

[Anonymous]

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