Too much data is shown

[Kunkulis]

Hi,

We have a massive QlikView application.
Once I have chosen the Main Date, it returns too much data:It should return information where Main Date=Tbl1 Date
But somehow from Main Date it chooses all the available information in the Tbl1 and Tbl2 

I tried putting this formula in MultiBox Expression =if([Main Date] = [Tbl1 Date], [Color in Tbl2]), but it just crashed the whole application and didn't load anything. The multibox had a big gray "X" over it.

This could be due to the fact that the application consist of many tables and the path to Main Date is long:

In the photo there is just the path it takes from one date to the other one, keep in mind that the link with each of the table could range between 1-8. Basically the "All tables connected" is the Main table where all the Keys.

[marcus_sommer · Accepted solution]

I think it couldn't be adjusted/corrected within the UI else the datamodel itself must be suitable with the right associations between all the data. From your description I assume that it is rather not an easy/quick adjustment else I believe a rethink of the whole datamodel will be needed.

- Marcus

[Kunkulis]

Now I am trying to copy the Tbl1 and Tbl2 and move them to link up directly with the main table