topic Re: Ignore Selection In a Text Object in QlikView https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303219#M405913 <HTML><HEAD></HEAD><BODY><P>what about this?</P><P></P><P>num(Count({1}FanID),'#,###')</P></BODY></HTML> Thu, 27 Jul 2017 14:04:52 GMT Frank_Hartmann 2017-07-27T14:04:52Z Ignore Selection In a Text Object https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303217#M405911 <HTML><HEAD></HEAD><BODY><P>I have a very simple text object:</P><P>=num(Count(FanID),'#,###')</P><P></P><P>I'd like to duplicate this and have it ignore selections, so that you can see how many fans you have selected out of the total amount.</P><P></P><P>For example, as you drill down in the application, I'd like to see that 10/100 people meet the current selection criteria while showing both numbers.</P><P></P><P>any suggestions would be very helpful!</P><P></P><P>thank you!</P></BODY></HTML> Thu, 27 Jul 2017 14:01:53 GMT https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303217#M405911 Anonymous 2017-07-27T14:01:53Z Re: Ignore Selection In a Text Object https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303218#M405912 <HTML><HEAD></HEAD><BODY><P>To disregard selections use</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=num(Count({1} FanID),'#,###')</SPAN></P></BODY></HTML> Thu, 27 Jul 2017 14:04:26 GMT https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303218#M405912 stigchel 2017-07-27T14:04:26Z Re: Ignore Selection In a Text Object https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303219#M405913 <HTML><HEAD></HEAD><BODY><P>what about this?</P><P></P><P>num(Count({1}FanID),'#,###')</P></BODY></HTML> Thu, 27 Jul 2017 14:04:52 GMT https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303219#M405913 Frank_Hartmann 2017-07-27T14:04:52Z Re: Ignore Selection In a Text Object https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303220#M405914 <HTML><HEAD></HEAD><BODY><P>The technique used is called Set Analysis, the 1 stands for</P><TABLE cellspacing="0" class="TableStyle-tableGrid" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"><TR style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TH class="BodyI--" style="padding: 7px; text-align: left; border: 1px solid #d5d5d5;">Identifier</TH><TH class="BodyG--" style="padding: 7px; text-align: left; border: 1px solid #d5d5d5;">Description</TH></TR><TR style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"><TD class="BodyI--" style="padding: 7px; border: 1px solid #d5d5d5;">1</TD><TD class="BodyG--" style="padding: 7px; border: 1px solid #d5d5d5;">Represents the full set of all the records in the application, irrespective of any selections made.</TD></TR></TBODY></TABLE><P>More on this topic</P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-analysis-expressions.htm">Set analysis and set expressions ‒ QlikView</A></P></BODY></HTML> Thu, 27 Jul 2017 14:17:49 GMT https://community.qlik.com/t5/QlikView/Ignore-Selection-In-a-Text-Object/m-p/1303220#M405914 stigchel 2017-07-27T14:17:49Z