topic Re: Counting and retaining field values in QlikView https://community.qlik.com/t5/QlikView/Counting-and-retaining-field-values/m-p/742883#M1034465 <HTML><HEAD></HEAD><BODY><P>it works but can u elaborate the code and provide screen shot </P></BODY></HTML> Thu, 22 Jan 2015 05:23:52 GMT 2015-01-22T05:23:52Z Counting and retaining field values https://community.qlik.com/t5/QlikView/Counting-and-retaining-field-values/m-p/742882#M1034462 <HTML><HEAD></HEAD><BODY><P>Hoping someone can help me out here. I have customer data with a column dedicated to each particular year. My dashboard currently features two text boxes; one with a total customer count, and the other with a percentage (%) value of the total number of customers. What I'd like to do is have is either a third text box with the percentage (%) value taken from the selected year only OR a box featuring percentage (%) values for each year individually.</P><P></P><P>Does anyone know whether this is possible. I'm getting myself confused.</P><P></P><P>Much appreciated.</P><P></P><P>Matt</P></BODY></HTML> Wed, 21 Jan 2015 15:19:15 GMT https://community.qlik.com/t5/QlikView/Counting-and-retaining-field-values/m-p/742882#M1034462 mattphillip 2015-01-21T15:19:15Z Re: Counting and retaining field values https://community.qlik.com/t5/QlikView/Counting-and-retaining-field-values/m-p/742883#M1034465 <HTML><HEAD></HEAD><BODY><P>it works but can u elaborate the code and provide screen shot </P></BODY></HTML> Thu, 22 Jan 2015 05:23:52 GMT https://community.qlik.com/t5/QlikView/Counting-and-retaining-field-values/m-p/742883#M1034465 2015-01-22T05:23:52Z Re: Counting and retaining field values https://community.qlik.com/t5/QlikView/Counting-and-retaining-field-values/m-p/742884#M1034467 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>try like this</P><P>num(avg({&lt;year={$(=max(year))}&gt;}customer),'#,##0%')</P><P>or provide sample</P></BODY></HTML> Thu, 22 Jan 2015 06:45:04 GMT https://community.qlik.com/t5/QlikView/Counting-and-retaining-field-values/m-p/742884#M1034467 arulsettu 2015-01-22T06:45:04Z