Hi, i am working on a report like the example above, where i have two tables in different formats which consolidated in tableConsolidated. Now i want to filter the TableConsolidated based on the fields from Table2, using the fields Type, Activity or any other field from this table. I Assume that since i link the 2 tables based on the field ID i could do this, but when i try to filter the field 'Type' selecting 'A', the TableConsolidated shows the result below:
What i expect was only the dates that has an "A" in the "'Type" field. What kind of link do i have to do? In my complete table i have more than 20 field from table2 that i wish to filter in TableConsolidated
How do you do your filter now in the load script? While the load script is running there is no links between any tables. It is when the load script is about to finish that QlikView goes through it's association procedure and establish the resulting data model for the running application and/or the finally saved and reloaded QVW-file.
Hi Petter, Follow attached part of my report. Table SITES is my Table1, REWORK my Table2 and DATAS my TableConsolidated. I created a filter "ReworkActivity" which is my "Type" from Table2. And [%Key field] is my ID. In The Graph i have two activities that can be filtered in Rework Activity selecting SI or WR. As you can see, if you filter the tables, the graph shows the right result, but if you filter the field "ReworkActivitY", for example "SI", it does not shows only the results for SI in Table2, it shows the result for every ID ([%Key field]).
Obs. You will not be able to reload because it access an intranet SharePoint.
ECM - Engineering Production Report PA12 (QlikCommunitie).qvw
Well if you want the graph to only show activities for ReworkActivity that happens for DATASTypeField = Table 2 without specifically selecting Table 2 in the Tables list box you could simply put in a Set Expression in your Sum() expression in the chart (graph):
In fact i want to select for example "SI" in ReworkActivity from table2, and it filter in table consolidated only the values that has SI atribute. In this case, show only "0.1.8 SI Rework" and exclude "1.1.8 WR Rework" from the graph.