topic Re: Selection - Dividing a dimension between two graphs (pivot) in QlikView https://community.qlik.com/t5/QlikView/Selection-Dividing-a-dimension-between-two-graphs-pivot/m-p/360116#M574245 <HTML><HEAD></HEAD><BODY><P>Hi Bilge,</P><P></P><P>Awesome advice, works exactly the way i wanted it too.</P><P></P><P>Cheers,</P><P>Ben</P></BODY></HTML> Thu, 21 Jun 2012 02:55:09 GMT 2012-06-21T02:55:09Z Selection - Dividing a dimension between two graphs (pivot) https://community.qlik.com/t5/QlikView/Selection-Dividing-a-dimension-between-two-graphs-pivot/m-p/360114#M574243 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I'm trying to split out a section of data by State/Interstate.</P><P></P><P>I've got a 2 pivot tables setup with different expressions, but with a common dimension (state). I want one to display the current state selected, and the other to display the excluded state options (at the same time).</P><P></P><P>I believe that Set Analysis is the best way to do this, but of course that is limited to aggregation functions. I've tried to use different variations of aggr() and Only() but i just can't get it right. </P><P></P><P>At present my calculated dimension formula looks like this:</P><P></P><P>= <SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Only</SPAN><SPAN style="font-size: 8pt;">({1-$} </SPAN><SPAN style="color: #800000; font-size: 8pt;">sSalesState</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #800000; font-size: 8pt;">sSalesState</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I know this is completely wrong, and i'm not 100% that it's possible at all.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Any advice you guys could offer is most appreciated.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Cheers,</SPAN></P><P><SPAN style="font-size: 10pt;">Ben</SPAN></P></BODY></HTML> Wed, 20 Jun 2012 03:36:57 GMT https://community.qlik.com/t5/QlikView/Selection-Dividing-a-dimension-between-two-graphs-pivot/m-p/360114#M574243 2012-06-20T03:36:57Z Re: Selection - Dividing a dimension between two graphs (pivot) https://community.qlik.com/t5/QlikView/Selection-Dividing-a-dimension-between-two-graphs-pivot/m-p/360115#M574244 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do you need something like in the attached file?</P><P></P><P>Best regards,</P><P></P><P><A class="loading" href="http://quickdevtips.blogspot.com/" title="http://quickdevtips.blogspot.com/">http://quickdevtips.blogspot.com/</A></P></BODY></HTML> Wed, 20 Jun 2012 04:35:53 GMT https://community.qlik.com/t5/QlikView/Selection-Dividing-a-dimension-between-two-graphs-pivot/m-p/360115#M574244 2012-06-20T04:35:53Z Re: Selection - Dividing a dimension between two graphs (pivot) https://community.qlik.com/t5/QlikView/Selection-Dividing-a-dimension-between-two-graphs-pivot/m-p/360116#M574245 <HTML><HEAD></HEAD><BODY><P>Hi Bilge,</P><P></P><P>Awesome advice, works exactly the way i wanted it too.</P><P></P><P>Cheers,</P><P>Ben</P></BODY></HTML> Thu, 21 Jun 2012 02:55:09 GMT https://community.qlik.com/t5/QlikView/Selection-Dividing-a-dimension-between-two-graphs-pivot/m-p/360116#M574245 2012-06-21T02:55:09Z