topic Show Values for Total and for Selection in QlikView https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408734#M151976 <HTML><HEAD></HEAD><BODY><P>I hope someone can provde some guidance. I am develping an application in whihc the user can select a branch (or more) and a series of comm,on charts are creted. This is pretty standard stuff and typicl in qview. In addition the charts have a dimension of type of customers and we show the measures for each type) - attaching&nbsp; sample chart</P><P></P><P>The client also wants me to show the same measures for the entire set of customers - not only those that have to do with that branch - so in my chart I would likely show values on the axis (and no bars) for all the customers (these are in fact what thebars would show if I had not selected any branch) </P><P></P><P>The question is that I do not seem to know if I can calculate the figures for all the data records overriding the selection, and how to do it</P><P></P><P>the percentages shown are calculated using sum(hh) / sum(total&lt;hh&gt; hh) (HH is a dummy variable that has 1 for every row), thereare likely other ways but this is the one I used this time</P><P></P><P>the 2 dimensions I show are defined as follows, the distance to branch is a set of nested if statements that convert a continuous variable to the ranges I show, the type of customer is data I load, each HH on the main table i slinked to one or more rowsa that shows the branches it touches with how they touch it</P><P></P><P>that table looks like</P><P></P><P>HHID&nbsp;&nbsp;&nbsp;&nbsp; Branch&nbsp;&nbsp;&nbsp; Type</P><P>xxxxx&nbsp;&nbsp;&nbsp; 00017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001</P><P></P><P>(I also have a aux table that converts vlue slike 001, 010, etcd to the names you see)</P><P></P><P>so when I select a branch in a selction box it take sonly those HHs that touch that branch and</P><P></P><P>Thanks</P></BODY></HTML> Tue, 06 Nov 2012 17:27:30 GMT 2012-11-06T17:27:30Z Show Values for Total and for Selection https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408734#M151976 <HTML><HEAD></HEAD><BODY><P>I hope someone can provde some guidance. I am develping an application in whihc the user can select a branch (or more) and a series of comm,on charts are creted. This is pretty standard stuff and typicl in qview. In addition the charts have a dimension of type of customers and we show the measures for each type) - attaching&nbsp; sample chart</P><P></P><P>The client also wants me to show the same measures for the entire set of customers - not only those that have to do with that branch - so in my chart I would likely show values on the axis (and no bars) for all the customers (these are in fact what thebars would show if I had not selected any branch) </P><P></P><P>The question is that I do not seem to know if I can calculate the figures for all the data records overriding the selection, and how to do it</P><P></P><P>the percentages shown are calculated using sum(hh) / sum(total&lt;hh&gt; hh) (HH is a dummy variable that has 1 for every row), thereare likely other ways but this is the one I used this time</P><P></P><P>the 2 dimensions I show are defined as follows, the distance to branch is a set of nested if statements that convert a continuous variable to the ranges I show, the type of customer is data I load, each HH on the main table i slinked to one or more rowsa that shows the branches it touches with how they touch it</P><P></P><P>that table looks like</P><P></P><P>HHID&nbsp;&nbsp;&nbsp;&nbsp; Branch&nbsp;&nbsp;&nbsp; Type</P><P>xxxxx&nbsp;&nbsp;&nbsp; 00017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001</P><P></P><P>(I also have a aux table that converts vlue slike 001, 010, etcd to the names you see)</P><P></P><P>so when I select a branch in a selction box it take sonly those HHs that touch that branch and</P><P></P><P>Thanks</P></BODY></HTML> Tue, 06 Nov 2012 17:27:30 GMT https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408734#M151976 2012-11-06T17:27:30Z Re: Show Values for Total and for Selection https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408735#M151977 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Just two words can help you: set analysis (look at help).</P><P>For example to calculate the sum discarding all selctions you could use Sum({1} Value).</P></BODY></HTML> Tue, 06 Nov 2012 18:06:34 GMT https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408735#M151977 whiteline 2012-11-06T18:06:34Z Re: Show Values for Total and for Selection https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408736#M151978 <HTML><HEAD></HEAD><BODY><P>will look into that. Much appreciated</P></BODY></HTML> Tue, 06 Nov 2012 18:38:41 GMT https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408736#M151978 2012-11-06T18:38:41Z Re: Show Values for Total and for Selection https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408737#M151979 <HTML><HEAD></HEAD><BODY><P>will look into that. Much appreciated</P></BODY></HTML> Tue, 06 Nov 2012 18:49:27 GMT https://community.qlik.com/t5/QlikView/Show-Values-for-Total-and-for-Selection/m-p/408737#M151979 2012-11-06T18:49:27Z