topic how to link tables using set analysis? in QlikView https://community.qlik.com/t5/QlikView/how-to-link-tables-using-set-analysis/m-p/204059#M61135 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Sorry for my english....</P><P>I have two tables with no link, I would like link them in pivot table.</P><P>exemple:</P><P>"shop" and "Rack" are my dimension. <B></B></P><P style="font-weight: bold"></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><B>sum<BR /></B> <B></B><B><BR /><BR /></B> <B></B><BR /> <B></B>({&lt;<B>Mag</B>=P(<B>shop</B>),<B>Ray</B>=P(<B>Rack</B>)&gt;}<B>Obj</B>)</PRE><BR /><BR /> <P>but this expression doesn't work, the dimension was not use in my pivot table, the result is the sum of "Obj" for ALL "shop" and "Rack"...</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">sum({&lt;<B>Mag</B>={'1'],<B>Ray</B>={'2'})&gt;}<B>Obj</B>) this is ok but juste for Shop 1 and rack 2....</PRE><BR /><BR /> <P></P><P></P><P>thx</P><BR /><BR /> <P>how to select data in a alone table which value of my dimensions in a pivot table?</P></BODY></HTML> Thu, 01 Oct 2009 15:43:08 GMT bm59 2009-10-01T15:43:08Z how to link tables using set analysis? https://community.qlik.com/t5/QlikView/how-to-link-tables-using-set-analysis/m-p/204059#M61135 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Sorry for my english....</P><P>I have two tables with no link, I would like link them in pivot table.</P><P>exemple:</P><P>"shop" and "Rack" are my dimension. <B></B></P><P style="font-weight: bold"></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><B>sum<BR /></B> <B></B><B><BR /><BR /></B> <B></B><BR /> <B></B>({&lt;<B>Mag</B>=P(<B>shop</B>),<B>Ray</B>=P(<B>Rack</B>)&gt;}<B>Obj</B>)</PRE><BR /><BR /> <P>but this expression doesn't work, the dimension was not use in my pivot table, the result is the sum of "Obj" for ALL "shop" and "Rack"...</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">sum({&lt;<B>Mag</B>={'1'],<B>Ray</B>={'2'})&gt;}<B>Obj</B>) this is ok but juste for Shop 1 and rack 2....</PRE><BR /><BR /> <P></P><P></P><P>thx</P><BR /><BR /> <P>how to select data in a alone table which value of my dimensions in a pivot table?</P></BODY></HTML> Thu, 01 Oct 2009 15:43:08 GMT https://community.qlik.com/t5/QlikView/how-to-link-tables-using-set-analysis/m-p/204059#M61135 bm59 2009-10-01T15:43:08Z how to link tables using set analysis? https://community.qlik.com/t5/QlikView/how-to-link-tables-using-set-analysis/m-p/204060#M61136 <HTML><HEAD></HEAD><BODY><P>Maybe you have problems with the pivot dimension changing your results.</P><P>I included an example using your expression on text objects and it is working fine.</P><P>Regards,</P><P></P><P>Erich</P></BODY></HTML> Wed, 07 Oct 2009 05:17:37 GMT https://community.qlik.com/t5/QlikView/how-to-link-tables-using-set-analysis/m-p/204060#M61136 erichshiino 2009-10-07T05:17:37Z