topic Baseline Expression in QlikView https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153556#M30552 <HTML><HEAD></HEAD><BODY><P>How do you create a chart with two exprressions with one of them being a Total or Company trend with the second being a filtered dimention (ie store, state, etc)?</P></BODY></HTML> Tue, 17 Nov 2009 04:10:23 GMT 2009-11-17T04:10:23Z Baseline Expression https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153556#M30552 <HTML><HEAD></HEAD><BODY><P>How do you create a chart with two exprressions with one of them being a Total or Company trend with the second being a filtered dimention (ie store, state, etc)?</P></BODY></HTML> Tue, 17 Nov 2009 04:10:23 GMT https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153556#M30552 2009-11-17T04:10:23Z Baseline Expression https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153557#M30553 <HTML><HEAD></HEAD><BODY><P>Use SET ANALISYS</P></BODY></HTML> Tue, 17 Nov 2009 04:21:28 GMT https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153557#M30553 2009-11-17T04:21:28Z Baseline Expression https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153558#M30554 <HTML><HEAD></HEAD><BODY><P>ok, I'm new, what is SET ANALYSIS?</P></BODY></HTML> Tue, 17 Nov 2009 04:26:51 GMT https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153558#M30554 2009-11-17T04:26:51Z Baseline Expression https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153559#M30555 <HTML><HEAD></HEAD><BODY><P>Set Analysis is a means by which you can limit the data set you're performing analysis on using a special syntax. Assuming you're using Qlikview 9, the details can be found in the Qlikview Reference Manual in Book 3, page 353 (or page 1754 of the PDF).</P><P>i.e.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Sum({ $ &lt; State={UT,AZ} &gt; } sales)<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>Hope this helps.</P><P>-Alex</P></BODY></HTML> Tue, 17 Nov 2009 07:49:57 GMT https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153559#M30555 2009-11-17T07:49:57Z Baseline Expression https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153560#M30556 <HTML><HEAD></HEAD><BODY><P>Thanks for the tip! Works great!!<IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Wed, 18 Nov 2009 04:04:07 GMT https://community.qlik.com/t5/QlikView/Baseline-Expression/m-p/153560#M30556 2009-11-18T04:04:07Z