topic I need some help to limit my data in QlikView https://community.qlik.com/t5/QlikView/I-need-some-help-to-limit-my-data/m-p/253946#M1183063 <HTML><HEAD></HEAD><BODY><P> worked like a charm, thanks!</P></BODY></HTML> Thu, 24 Nov 2011 14:55:37 GMT 2011-11-24T14:55:37Z I need some help to limit my data https://community.qlik.com/t5/QlikView/I-need-some-help-to-limit-my-data/m-p/253944#M1183061 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have a dimension called Business Unit which I would like to limit to the value BIG in one of my graphs, hope you can help me.</P><P></P><P>The expression is "Net Sales (' &amp; Valuta &amp;') and I want the definition to limit the result to Business Unit BIG if possible?</P><P></P><P>The Defiinition of Net Sales is currently: </P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><SPAN style="color: #0000ff; font-size: 8pt;"><P>Sum </P></SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">RRResultatPost</SPAN><SPAN style="font-size: 8pt;"> = {'Net Sales'}&gt;} Amount_</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(vCurr)</EM></STRONG></EM></STRONG><P><EM style="color: #808080; font-size: 8pt;"><EM style="color: #808080; font-size: 8pt;"> </EM></EM></P><P>Thanks!</P><P></P></BODY></HTML> Thu, 24 Nov 2011 14:44:14 GMT https://community.qlik.com/t5/QlikView/I-need-some-help-to-limit-my-data/m-p/253944#M1183061 2011-11-24T14:44:14Z I need some help to limit my data https://community.qlik.com/t5/QlikView/I-need-some-help-to-limit-my-data/m-p/253945#M1183062 <HTML><HEAD></HEAD><BODY><P>Maybe like this?</P><P></P><P>Sum </P><P><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">RRResultatPost</SPAN><SPAN style="font-size: 8pt;"> = {'Net Sales'}, <STRONG>[Business Unit]= {'BIG'}</STRONG> &gt;} Amount_</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(vCurr) )</EM></STRONG></EM></STRONG></P></BODY></HTML> Thu, 24 Nov 2011 14:51:22 GMT https://community.qlik.com/t5/QlikView/I-need-some-help-to-limit-my-data/m-p/253945#M1183062 swuehl 2011-11-24T14:51:22Z I need some help to limit my data https://community.qlik.com/t5/QlikView/I-need-some-help-to-limit-my-data/m-p/253946#M1183063 <HTML><HEAD></HEAD><BODY><P> worked like a charm, thanks!</P></BODY></HTML> Thu, 24 Nov 2011 14:55:37 GMT https://community.qlik.com/t5/QlikView/I-need-some-help-to-limit-my-data/m-p/253946#M1183063 2011-11-24T14:55:37Z