topic Ignore Dimensions in chart set analysis in QlikView https://community.qlik.com/t5/QlikView/Ignore-Dimensions-in-chart-set-analysis/m-p/836379#M471174 <HTML><HEAD></HEAD><BODY><P>Good Day ,</P><P>I have a straight table with thse figures:</P><P><STRONG><EM>dimension</EM></STRONG><STRONG><EM> :&nbsp; Month </EM></STRONG></P><P><STRONG><EM>expression count(ID)</EM></STRONG></P><P>Chart 1:<SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp; </SPAN></P><TABLE border="1px" cellpadding="0" cellspacing="0" height="96" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 99px; height: 89px; border-width: 1px; border-style: solid;"><TBODY><TR><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Month</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Total</TH></TR><TR><TD height="20" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Jan</TD><TD align="right" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Feb</TD><TD align="right" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">12</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Mar</TD><TD align="right" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14</TD></TR></TBODY></TABLE><P></P><P> Now i want to ignore the Dimension using set analysis </P><P>so that my end result is like this :</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp; </SPAN></P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 146px; border-width: 1px; border-style: solid;"><TBODY><TR><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Month </TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">PrevMonTotal</TH></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Jan</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">0</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Feb</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Mar</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">12</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Apr</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14</TD></TR></TBODY></TABLE><P></P><P></P><P>thanx in advance </P></BODY></HTML> Wed, 01 Apr 2015 13:23:49 GMT Anonymous 2015-04-01T13:23:49Z Ignore Dimensions in chart set analysis https://community.qlik.com/t5/QlikView/Ignore-Dimensions-in-chart-set-analysis/m-p/836379#M471174 <HTML><HEAD></HEAD><BODY><P>Good Day ,</P><P>I have a straight table with thse figures:</P><P><STRONG><EM>dimension</EM></STRONG><STRONG><EM> :&nbsp; Month </EM></STRONG></P><P><STRONG><EM>expression count(ID)</EM></STRONG></P><P>Chart 1:<SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp; </SPAN></P><TABLE border="1px" cellpadding="0" cellspacing="0" height="96" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 99px; height: 89px; border-width: 1px; border-style: solid;"><TBODY><TR><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Month</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Total</TH></TR><TR><TD height="20" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Jan</TD><TD align="right" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Feb</TD><TD align="right" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">12</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Mar</TD><TD align="right" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14</TD></TR></TBODY></TABLE><P></P><P> Now i want to ignore the Dimension using set analysis </P><P>so that my end result is like this :</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp; </SPAN></P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 146px; border-width: 1px; border-style: solid;"><TBODY><TR><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Month </TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">PrevMonTotal</TH></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Jan</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">0</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Feb</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Mar</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">12</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Apr</TD><TD align="right" style="color: #575757; text-align: -webkit-right; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14</TD></TR></TBODY></TABLE><P></P><P></P><P>thanx in advance </P></BODY></HTML> Wed, 01 Apr 2015 13:23:49 GMT https://community.qlik.com/t5/QlikView/Ignore-Dimensions-in-chart-set-analysis/m-p/836379#M471174 Anonymous 2015-04-01T13:23:49Z Re: Ignore Dimensions in chart set analysis https://community.qlik.com/t5/QlikView/Ignore-Dimensions-in-chart-set-analysis/m-p/836380#M471175 <HTML><HEAD></HEAD><BODY><P>The Set Analysis is global for the chart - i.e. it is not evaluated row-by-row. The best way to solve this problem is to use</P><P>&nbsp;&nbsp;&nbsp;&nbsp; RangeSum(Above(Count(ID)))</P><P></P><P>Then you get the value from previous row.</P><P></P><P>HIC</P></BODY></HTML> Wed, 01 Apr 2015 13:29:41 GMT https://community.qlik.com/t5/QlikView/Ignore-Dimensions-in-chart-set-analysis/m-p/836380#M471175 hic 2015-04-01T13:29:41Z