Too much data is shown

Kunkulis — Sat, 16 Nov 2024 04:11:17 GMT

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.

topic Too much data is shown in QlikView

Too much data is shown