topic Re: 100% of the Data in QlikView https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530611#M1127274 <HTML><HEAD></HEAD><BODY><P>Seems like you've deleted some posts and the responses attached, which is not a good idea, since it breaks the history of a discussion and confuses not only the ones that already took part.</P><P></P><P>I am reattaching the modified document. I haven't understood your latest comments (now deleted <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> ), so if there are any open issues, please repost.</P></BODY></HTML> Sat, 28 Dec 2013 15:02:47 GMT swuehl 2013-12-28T15:02:47Z 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530607#M1127266 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>PFA,</P><P></P><P>i want to show 100% of data..</P></BODY></HTML> Fri, 27 Dec 2013 17:45:16 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530607#M1127266 2013-12-27T17:45:16Z Re: 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530608#M1127268 <HTML><HEAD></HEAD><BODY><P><STRONG>Sunil</STRONG></P><P></P><P>Did you mean to attach something ?</P><P></P><P>Also could you expand on your question, it is more than a little vague.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Fri, 27 Dec 2013 17:49:02 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530608#M1127268 Anonymous 2013-12-27T17:49:02Z Re: 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530609#M1127270 <HTML><HEAD></HEAD><BODY><P>Hi Sunil,</P><P></P><P>Elaborate little briefly question, we are not find any attachment here.</P></BODY></HTML> Sat, 28 Dec 2013 13:15:35 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530609#M1127270 2013-12-28T13:15:35Z Re: 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530610#M1127272 <HTML><HEAD></HEAD><BODY><P>In any expression you can ignore any selections and show the totals for the entire data set using Set Analysis.&nbsp; The prefix '1' can be used to specify the whole set, and it can be used on it's own without any qualifier, so you could have this as an expression:</P><P></P><P><STRONG>sum({1}Value)</STRONG></P><P></P><P>As well as giving you a total value, regardless of selections this will also cause all dimensions to show.</P><P></P><P>You need to ensure you make users aware that the expression isn't based on the selection - perhaps by means of a text box explaining this.</P><P></P><P>Hope that answers your question - if not please elaborate on what your question was.</P><P></P><P>- Steve</P></BODY></HTML> Sat, 28 Dec 2013 14:34:16 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530610#M1127272 stevedark 2013-12-28T14:34:16Z Re: 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530611#M1127274 <HTML><HEAD></HEAD><BODY><P>Seems like you've deleted some posts and the responses attached, which is not a good idea, since it breaks the history of a discussion and confuses not only the ones that already took part.</P><P></P><P>I am reattaching the modified document. I haven't understood your latest comments (now deleted <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> ), so if there are any open issues, please repost.</P></BODY></HTML> Sat, 28 Dec 2013 15:02:47 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530611#M1127274 swuehl 2013-12-28T15:02:47Z Re: 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530612#M1127276 <HTML><HEAD></HEAD><BODY><P>Again, lot of posts seem to get deleted from this thread.</P><P></P><P>Whoever is responsible for that, please don't do it!</P></BODY></HTML> Sun, 29 Dec 2013 18:25:53 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530612#M1127276 swuehl 2013-12-29T18:25:53Z Re: 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530613#M1127277 <HTML><HEAD></HEAD><BODY><P>I've just realised that where I have been sending responses via email to</P><P>deleted posts these have just been ditched by Jive. Intensely frustrating.</P><P></P><P>-Steve</P></BODY></HTML> Mon, 30 Dec 2013 09:02:54 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530613#M1127277 stevedark 2013-12-30T09:02:54Z Re: 100% of the Data https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530614#M1127278 <HTML><HEAD></HEAD><BODY><P>Sorry for that.</P><P>Really i don't know what happend</P></BODY></HTML> Mon, 30 Dec 2013 13:15:36 GMT https://community.qlik.com/t5/QlikView/100-of-the-Data/m-p/530614#M1127278 2013-12-30T13:15:36Z