topic Keeping the Total Count Constant in QlikView https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388103#M422459 <HTML><HEAD></HEAD><BODY><P>Hi Guys ,</P><P></P><P>So I have a query where I'd want to show the total count which is shown in the two images here below. </P><P><IMG alt="month.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186574_month.PNG" style="height: auto; width: auto;" /> </P><P>But as soon as I make a Selection I must have the total count not change for any of the selections made.</P><P>So that I can tally from the count of the month vs the total count that was made entirely. </P><P><IMG alt="check2.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/186584_check2.PNG" style="height: auto; width: auto;" /><IMG alt="check.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/186583_check.PNG" style="font-size: 13.3333px; height: auto; width: auto;" /></P><P>How should I Proceed Further ?</P><P>Thanks for help !</P><P><BR />Regards,</P><P>Abhay</P></BODY></HTML> Tue, 12 Dec 2017 09:35:29 GMT abhaytrip 2017-12-12T09:35:29Z Keeping the Total Count Constant https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388103#M422459 <HTML><HEAD></HEAD><BODY><P>Hi Guys ,</P><P></P><P>So I have a query where I'd want to show the total count which is shown in the two images here below. </P><P><IMG alt="month.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186574_month.PNG" style="height: auto; width: auto;" /> </P><P>But as soon as I make a Selection I must have the total count not change for any of the selections made.</P><P>So that I can tally from the count of the month vs the total count that was made entirely. </P><P><IMG alt="check2.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/186584_check2.PNG" style="height: auto; width: auto;" /><IMG alt="check.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/186583_check.PNG" style="font-size: 13.3333px; height: auto; width: auto;" /></P><P>How should I Proceed Further ?</P><P>Thanks for help !</P><P><BR />Regards,</P><P>Abhay</P></BODY></HTML> Tue, 12 Dec 2017 09:35:29 GMT https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388103#M422459 abhaytrip 2017-12-12T09:35:29Z Re: Keeping the Total Count Constant https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388104#M422460 <HTML><HEAD></HEAD><BODY><P>add {1} inside Your countexpression maybe</P></BODY></HTML> Tue, 12 Dec 2017 09:37:49 GMT https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388104#M422460 stabben23 2017-12-12T09:37:49Z Re: Keeping the Total Count Constant https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388105#M422461 <HTML><HEAD></HEAD><BODY><P>count({1} Total Fieldname)</P></BODY></HTML> Tue, 12 Dec 2017 09:40:37 GMT https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388105#M422461 Anonymous 2017-12-12T09:40:37Z Re: Keeping the Total Count Constant https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388106#M422462 <HTML><HEAD></HEAD><BODY><P>maybe in Total count expression - <STRONG>Sum(Total &lt;your dimension&gt; Count) </STRONG>or<STRONG> just Sum(Total Count)</STRONG></P></BODY></HTML> Tue, 12 Dec 2017 09:41:22 GMT https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388106#M422462 supriyabiware 2017-12-12T09:41:22Z Re: Keeping the Total Count Constant https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388107#M422463 <HTML><HEAD></HEAD><BODY><P>Oh yes , That did help !<BR />Thanks alot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /><BR />Since im new to Qlik , im learning from yall.</P></BODY></HTML> Tue, 12 Dec 2017 09:42:18 GMT https://community.qlik.com/t5/QlikView/Keeping-the-Total-Count-Constant/m-p/1388107#M422463 abhaytrip 2017-12-12T09:42:18Z