topic Linking tables in QlikView https://community.qlik.com/t5/QlikView/Linking-tables/m-p/669941#M243449 <HTML><HEAD></HEAD><BODY><P>In attachment the table viewer and a table I made in QlikView.</P><P></P><P>The idea is to count the emptyings_id</P><P>with the dimension on top fraction name (tbl listitem_dotation_fraction)</P><P>Main city is the project_level_name (tbl project_levels)</P><P>And route is collection_route_name (tbl collection_routes)</P><P></P><P>He seems to make the connection to the fraction, but doesn't make a difference between the route names.</P><P></P><P>Can anyone see why that is?</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Tue, 29 Jul 2014 08:16:36 GMT 2014-07-29T08:16:36Z Linking tables https://community.qlik.com/t5/QlikView/Linking-tables/m-p/669941#M243449 <HTML><HEAD></HEAD><BODY><P>In attachment the table viewer and a table I made in QlikView.</P><P></P><P>The idea is to count the emptyings_id</P><P>with the dimension on top fraction name (tbl listitem_dotation_fraction)</P><P>Main city is the project_level_name (tbl project_levels)</P><P>And route is collection_route_name (tbl collection_routes)</P><P></P><P>He seems to make the connection to the fraction, but doesn't make a difference between the route names.</P><P></P><P>Can anyone see why that is?</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Tue, 29 Jul 2014 08:16:36 GMT https://community.qlik.com/t5/QlikView/Linking-tables/m-p/669941#M243449 2014-07-29T08:16:36Z Re: Linking tables https://community.qlik.com/t5/QlikView/Linking-tables/m-p/669942#M243450 <HTML><HEAD></HEAD><BODY><P>I made an example (qvw in attachment)</P><P></P><P>Everything is working just fine, with correct numbers.</P><P>Until you select a project or projectlevel, then he does not make the seperation between the fractions.</P><P>(emptyings 3 in the qvw file)</P><P></P><P>I hope someone can help me!</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Tue, 29 Jul 2014 09:57:05 GMT https://community.qlik.com/t5/QlikView/Linking-tables/m-p/669942#M243450 2014-07-29T09:57:05Z