topic Re: Setting a table to COUNT different dimensions in QlikView https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387996#M489320 <HTML><HEAD></HEAD><BODY><P>Hi thank yoiu for your quick response.</P><P></P><P>I implemented everything as you described and i finally see the table exactly as i want... but....</P><P>when i select the customer from the other table for the analysis, all the numbers changed and the counters show me the details of that specific customer (# services, # activities).</P><P></P><P>Is it possible to force the table not to change the numbers inside?</P></BODY></HTML> Wed, 31 Oct 2012 13:23:12 GMT 2012-10-31T13:23:12Z Setting a table to COUNT different dimensions https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387994#M489318 <HTML><HEAD></HEAD><BODY><P>Hi all, sorry to bother you but i started last weekend to use QV.</P><P></P><P>I have different excel sheets that i use as source and all the data are connected.</P><P>I imported them into QV and started to make a dashboard.</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="114" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 404px; HEIGHT: 116px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>CUSTOMER</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SERVICE</STRONG></SPAN></TH></TR><TR><TD>A</TD><TD>service1</TD></TR><TR><TD>A</TD><TD>service2</TD></TR><TR><TD>B</TD><TD>service2</TD></TR><TR><TD>C</TD><TD>service3</TD></TR><TR><TD>D</TD><TD>service1</TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="155" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 400px; HEIGHT: 153px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SERVICE</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ACTIVITY</STRONG></SPAN></TH></TR><TR><TD>service1</TD><TD>activity1</TD></TR><TR><TD>service1</TD><TD>activity2</TD></TR><TR><TD>service1</TD><TD>activity3</TD></TR><TR><TD>service2</TD><TD>activity1</TD></TR><TR><TD>service3</TD><TD>activity2</TD></TR><TR><TD>service3</TD><TD>activity3</TD></TR></TBODY></TABLE><P></P><P></P><P>Now i would like to COUNT how many DISTINCT Customer, how many DISTINCT services and how many DISTINCT activities are there and foinally put them in a table.</P><P>Kind like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="88" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 398px; HEIGHT: 90px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DIMENSION</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>COUNTER</STRONG></SPAN></TH></TR><TR><TD># Customers</TD><TD>4</TD></TR><TR><TD># Services</TD><TD>3</TD></TR><TR><TD># Activities</TD><TD>3</TD></TR></TBODY></TABLE><P></P><P>I also would like this stats to remain fixed while i select and analyse the rest.</P><P>Actually i created 3 different text box with the expression " = COUNT (DISTINCT Customer) " but the number inside changes to 1 as i start to select and analyse the data.</P><P></P><P>Do i need to create 3 variables to store the counters? How and where i can do that?</P><P></P><P>Help meeeeeeee!!!</P><P></P><P>Thanks and have a nice day</P></BODY></HTML> Wed, 31 Oct 2012 11:33:37 GMT https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387994#M489318 2012-10-31T11:33:37Z Re: Setting a table to COUNT different dimensions https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387995#M489319 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Wed, 31 Oct 2012 11:58:48 GMT https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387995#M489319 Gysbert_Wassenaar 2012-10-31T11:58:48Z Re: Setting a table to COUNT different dimensions https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387996#M489320 <HTML><HEAD></HEAD><BODY><P>Hi thank yoiu for your quick response.</P><P></P><P>I implemented everything as you described and i finally see the table exactly as i want... but....</P><P>when i select the customer from the other table for the analysis, all the numbers changed and the counters show me the details of that specific customer (# services, # activities).</P><P></P><P>Is it possible to force the table not to change the numbers inside?</P></BODY></HTML> Wed, 31 Oct 2012 13:23:12 GMT https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387996#M489320 2012-10-31T13:23:12Z Re: Setting a table to COUNT different dimensions https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387997#M489321 <HTML><HEAD></HEAD><BODY><P>Yes, first clear all selections and then detach the table by checking the Detached option on the General tab of the properties screen.</P></BODY></HTML> Wed, 31 Oct 2012 13:32:54 GMT https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387997#M489321 Gysbert_Wassenaar 2012-10-31T13:32:54Z Re: Setting a table to COUNT different dimensions https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387998#M489322 <HTML><HEAD></HEAD><BODY><P>Great!!! <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P></P><P>Thank you very much!</P><P>One small step for a newbie....... <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P></BODY></HTML> Wed, 31 Oct 2012 13:48:01 GMT https://community.qlik.com/t5/QlikView/Setting-a-table-to-COUNT-different-dimensions/m-p/387998#M489322 2012-10-31T13:48:01Z