topic Re: How do I express data as a % of Count in a Line Graph in QlikView https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418033#M1161306 <HTML><HEAD></HEAD><BODY><P>Sorry rebeccad.</P><P></P><P>Complete novice here.</P><P></P><P>Where do I put that equation?</P><P></P><P> </P><P></P><P>Regards</P><P></P><P>Les Miles.</P></BODY></HTML> Fri, 07 Dec 2012 14:57:33 GMT 2012-12-07T14:57:33Z How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418023#M1161293 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I'm trying to express information over time as a %age of the total instances in a period.</P><P>So if there are 30 out of 100 this should be 30% but if 120 instance 30 should be 25%</P><P>Any guidance please</P></BODY></HTML> Fri, 07 Dec 2012 14:27:04 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418023#M1161293 2012-12-07T14:27:04Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418024#M1161294 <HTML><HEAD></HEAD><BODY><P>Usually a percentage would be Sum(FieldName)/Sum(TOTAL FieldName), but obviously this depends on your data.&nbsp; Do you have a sample file?</P></BODY></HTML> Fri, 07 Dec 2012 14:41:45 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418024#M1161294 2012-12-07T14:41:45Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418025#M1161295 <HTML><HEAD></HEAD><BODY><P>Sorry Rebeccad</P><P>Complete novice here.</P><P>Where should I put that equation?</P></BODY></HTML> Fri, 07 Dec 2012 14:52:29 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418025#M1161295 2012-12-07T14:52:29Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418026#M1161296 <HTML><HEAD></HEAD><BODY><P>Sorry Rebeccad</P><P>Complete novice here.</P><P>Where should I put that equation?</P></BODY></HTML> Fri, 07 Dec 2012 14:52:42 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418026#M1161296 2012-12-07T14:52:42Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418027#M1161297 <HTML><HEAD></HEAD><BODY><P>Sorry Rebeccad</P><P>Complete novice here.</P><P>Where should I put that equation?</P></BODY></HTML> Fri, 07 Dec 2012 14:53:04 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418027#M1161297 2012-12-07T14:53:04Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418028#M1161298 <HTML><HEAD></HEAD><BODY><P>Sorry Rebeccad</P><P>Complete novice here.</P><P>Where should I put that equation?</P></BODY></HTML> Fri, 07 Dec 2012 14:53:38 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418028#M1161298 2012-12-07T14:53:38Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418029#M1161300 <HTML><HEAD></HEAD><BODY><P>Sorry Rebeccad</P><P>Complete novice here.</P><P>Where should I put that equation?</P></BODY></HTML> Fri, 07 Dec 2012 14:54:00 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418029#M1161300 2012-12-07T14:54:00Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418030#M1161301 <HTML><HEAD></HEAD><BODY><P>Sorry Rebeccad</P><P>Complete novice here.</P><P>Where should I put that equation?</P></BODY></HTML> Fri, 07 Dec 2012 14:54:54 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418030#M1161301 2012-12-07T14:54:54Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418031#M1161303 <HTML><HEAD></HEAD><BODY><P>Under Chart Properties &gt; Expressions. </P><P></P><P>For example:</P><P><IMG __jive_id="26545" class="jive-image-thumbnail jive-image" onclick="" alt="Capture.JPG" src="https://community.qlik.com/legacyfs/online/26545_Capture.JPG" width="450" /></P></BODY></HTML> Fri, 07 Dec 2012 14:55:14 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418031#M1161303 2012-12-07T14:55:14Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418032#M1161304 <HTML><HEAD></HEAD><BODY><P>Sorry Rebeccad</P><P>Complete novice here.</P><P>Where should I put that equation?</P></BODY></HTML> Fri, 07 Dec 2012 14:55:22 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418032#M1161304 2012-12-07T14:55:22Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418033#M1161306 <HTML><HEAD></HEAD><BODY><P>Sorry rebeccad.</P><P></P><P>Complete novice here.</P><P></P><P>Where do I put that equation?</P><P></P><P> </P><P></P><P>Regards</P><P></P><P>Les Miles.</P></BODY></HTML> Fri, 07 Dec 2012 14:57:33 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418033#M1161306 2012-12-07T14:57:33Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418034#M1161307 <HTML><HEAD></HEAD><BODY><P>I get a completely different view</P><P><IMG __jive_id="26556" class="jive-image-thumbnail jive-image" onclick="" alt="ScreenHunter_88 Dec. 07 15.03.jpg" src="/legacyfs/online/26556_ScreenHunter_88 Dec. 07 15.03.jpg" width="450" /></P></BODY></HTML> Fri, 07 Dec 2012 15:07:59 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418034#M1161307 2012-12-07T15:07:59Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418035#M1161308 <HTML><HEAD></HEAD><BODY><P>Can you upload a sample file?</P></BODY></HTML> Fri, 07 Dec 2012 15:08:38 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418035#M1161308 CELAMBARASAN 2012-12-07T15:08:38Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418036#M1161310 <HTML><HEAD></HEAD><BODY><P>I have never seen that layout before.&nbsp; What version are you using?&nbsp; Try Count(CCRID)/Count(TOTAL CCRID).</P></BODY></HTML> Fri, 07 Dec 2012 15:09:52 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418036#M1161310 2012-12-07T15:09:52Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418037#M1161311 <HTML><HEAD></HEAD><BODY><P>Are you working in browser or web view in your Qlikview desktop?</P></BODY></HTML> Fri, 07 Dec 2012 15:11:12 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418037#M1161311 CELAMBARASAN 2012-12-07T15:11:12Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418038#M1161313 <HTML><HEAD></HEAD><BODY><P>Don't know about the version - is it because I'm on XP</P><P></P><P>Should I type that in the expression box?</P><P></P><P> </P><P></P><P>Regards</P><P></P><P>Les Miles.</P></BODY></HTML> Fri, 07 Dec 2012 15:13:45 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418038#M1161313 2012-12-07T15:13:45Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418039#M1161314 <HTML><HEAD></HEAD><BODY><P>No sorry Cela its on company server</P></BODY></HTML> Fri, 07 Dec 2012 15:14:29 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418039#M1161314 2012-12-07T15:14:29Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418040#M1161315 <HTML><HEAD></HEAD><BODY><P>Try typing it here:</P><P></P><P><IMG __jive_id="26558" class="jive-image-thumbnail jive-image" onclick="" alt="Capture.JPG" src="https://community.qlik.com/legacyfs/online/26558_Capture.JPG" width="450" /></P></BODY></HTML> Fri, 07 Dec 2012 15:15:38 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418040#M1161315 2012-12-07T15:15:38Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418041#M1161316 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> FYI</P><P></P><P> Its qv-9 web layout, you can change turn on/off it.. Any way you can use like </P><P></P><P>Count(CCRID)/Count(total CCRID)</P></BODY></HTML> Fri, 07 Dec 2012 15:19:45 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418041#M1161316 MayilVahanan 2012-12-07T15:19:45Z Re: How do I express data as a % of Count in a Line Graph https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418042#M1161317 <HTML><HEAD></HEAD><BODY><P>Ah, thanks Mayil.&nbsp; I have never used V.9 before.</P></BODY></HTML> Fri, 07 Dec 2012 15:20:43 GMT https://community.qlik.com/t5/QlikView/How-do-I-express-data-as-a-of-Count-in-a-Line-Graph/m-p/418042#M1161317 2012-12-07T15:20:43Z