https://community.qlik.com/t5/App-Development/How-to-count-the-unique-values-for-a-given-conidtion/m-p/1844376#M69872 <P>easy solution:</P><P>Count({1&lt;Label={'TRUE'}&gt;} distinct Label)</P> Fri, 08 Oct 2021 19:04:57 GMT aj_954 2021-10-08T19:04:57Z https://community.qlik.com/t5/App-Development/How-to-count-the-unique-values-for-a-given-conidtion/m-p/1844341#M69870 <P>Hi</P><P>I have a following example data:</P><P>Label T/F</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T</P><P>&nbsp;</P><P>I want to write a expression for a KSI that shows the *unique* times a the variable "label" gets assigned true. So in this example, it would be 2.</P><P>&nbsp;</P> Fri, 08 Oct 2021 17:53:12 GMT https://community.qlik.com/t5/App-Development/How-to-count-the-unique-values-for-a-given-conidtion/m-p/1844341#M69870 aj_954 2021-10-08T17:53:12Z https://community.qlik.com/t5/App-Development/How-to-count-the-unique-values-for-a-given-conidtion/m-p/1844376#M69872 <P>easy solution:</P><P>Count({1&lt;Label={'TRUE'}&gt;} distinct Label)</P> Fri, 08 Oct 2021 19:04:57 GMT https://community.qlik.com/t5/App-Development/How-to-count-the-unique-values-for-a-given-conidtion/m-p/1844376#M69872 aj_954 2021-10-08T19:04:57Z