topic Linking cross tables in QlikView https://community.qlik.com/t5/QlikView/Linking-cross-tables/m-p/751510#M1034593 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am new to QlikView and this community. I am inputting a Net Promoter Score Survey into click view and I am going through the comments field and Categorizing into 3 strengths and 3 weaknesses. As the categories are broad I have divided each category into sub categories so I have:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Strength 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Strength 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Strength 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SubStrength 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SubStrength 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SubStrength 3</STRONG></TH></TR><TR><TD style="padding: 2px;">Functionality &amp; upgrades</TD><TD style="padding: 2px;">General</TD><TD style="padding: 2px;">Service &amp; support</TD><TD style="padding: 2px;">Innovation</TD><TD style="padding: 2px;">Communication</TD><TD style="padding: 2px;">Keeps promises</TD></TR><TR><TD style="padding: 2px;">Service &amp; support</TD><TD style="padding: 2px;">General</TD><TD style="padding: 2px;">Sales &amp;&nbsp; Contracting</TD><TD style="padding: 2px;">Response times</TD><TD style="padding: 2px;">Professional</TD><TD style="padding: 2px;">Pricing</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Substrength 1 is a subset of the Strengths and are linked etc</P><P></P><P>I created a cross table for Strength 1, 2 &amp; 3, and I created a cross table of the substrengths. Can I link these two crosstables so that when I click on functionality &amp; upgrades I get a breakdown of the substrengths in that area?</P><P></P><P>Any help would be appreciated</P></BODY></HTML> Thu, 22 Jan 2015 15:23:31 GMT 2015-01-22T15:23:31Z Linking cross tables https://community.qlik.com/t5/QlikView/Linking-cross-tables/m-p/751510#M1034593 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am new to QlikView and this community. I am inputting a Net Promoter Score Survey into click view and I am going through the comments field and Categorizing into 3 strengths and 3 weaknesses. As the categories are broad I have divided each category into sub categories so I have:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Strength 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Strength 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Strength 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SubStrength 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SubStrength 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SubStrength 3</STRONG></TH></TR><TR><TD style="padding: 2px;">Functionality &amp; upgrades</TD><TD style="padding: 2px;">General</TD><TD style="padding: 2px;">Service &amp; support</TD><TD style="padding: 2px;">Innovation</TD><TD style="padding: 2px;">Communication</TD><TD style="padding: 2px;">Keeps promises</TD></TR><TR><TD style="padding: 2px;">Service &amp; support</TD><TD style="padding: 2px;">General</TD><TD style="padding: 2px;">Sales &amp;&nbsp; Contracting</TD><TD style="padding: 2px;">Response times</TD><TD style="padding: 2px;">Professional</TD><TD style="padding: 2px;">Pricing</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Substrength 1 is a subset of the Strengths and are linked etc</P><P></P><P>I created a cross table for Strength 1, 2 &amp; 3, and I created a cross table of the substrengths. Can I link these two crosstables so that when I click on functionality &amp; upgrades I get a breakdown of the substrengths in that area?</P><P></P><P>Any help would be appreciated</P></BODY></HTML> Thu, 22 Jan 2015 15:23:31 GMT https://community.qlik.com/t5/QlikView/Linking-cross-tables/m-p/751510#M1034593 2015-01-22T15:23:31Z