topic Re: values in dimension disregarding selections in QlikView https://community.qlik.com/t5/QlikView/values-in-dimension-disregarding-selections/m-p/1327250#M829647 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny!</P></BODY></HTML> Thu, 22 Jun 2017 12:46:05 GMT 2017-06-22T12:46:05Z values in dimension disregarding selections https://community.qlik.com/t5/QlikView/values-in-dimension-disregarding-selections/m-p/1327248#M829643 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>I have three fields <SPAN style="color: #575757;"> (<STRONG><EM>ID, product, sales</EM>). </STRONG></SPAN>One of them I use as a dimension (<EM><STRONG>product</STRONG></EM>) and one as an expression (<EM><STRONG>sales</STRONG></EM>) in a chart.</P><P>I want that dimension (<EM><STRONG>product</STRONG></EM>) shows only values, that depend on selections in <EM><STRONG>ID</STRONG></EM> field and do not depend on any selections in <EM><STRONG>product</STRONG></EM> field.&nbsp;&nbsp;&nbsp; </P><P></P><P><SPAN style="color: #575757;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167492_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P>In this case: when I select 001 in <EM><STRONG>ID</STRONG></EM> and cookie in <EM><STRONG>product</STRONG></EM> field, I want to see in product dimension <STRONG style="color: #ff00ff;">cookie and pie</STRONG> (and not only cookie!).</P><P> I suppose it should be solved with set analysis, but I need help. </P><P></P><P>Many thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/values-in-dimension-disregarding-selections/m-p/1327248#M829643 2020-11-25T16:16:04Z Re: values in dimension disregarding selections https://community.qlik.com/t5/QlikView/values-in-dimension-disregarding-selections/m-p/1327249#M829644 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>=Sum({&lt;product&gt;}sales)</STRONG></P><P></P><P><IMG __jive_id="167501" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167501_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 20 Jun 2017 15:14:32 GMT https://community.qlik.com/t5/QlikView/values-in-dimension-disregarding-selections/m-p/1327249#M829644 sunny_talwar 2017-06-20T15:14:32Z Re: values in dimension disregarding selections https://community.qlik.com/t5/QlikView/values-in-dimension-disregarding-selections/m-p/1327250#M829647 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny!</P></BODY></HTML> Thu, 22 Jun 2017 12:46:05 GMT https://community.qlik.com/t5/QlikView/values-in-dimension-disregarding-selections/m-p/1327250#M829647 2017-06-22T12:46:05Z