topic Re: Count of the possible values in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Count-of-the-possible-values-in-Set-Analysis/m-p/34616#M776323 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT {&lt;N_Factura_fac = e({&lt;LOGISTICA_FINANCIERA_fac = {'Financial'}&gt;})&gt;} N_Factura_fac)</STRONG></P></BODY></HTML> Mon, 30 Apr 2018 11:16:21 GMT sunny_talwar 2018-04-30T11:16:21Z Count of the possible values in Set Analysis https://community.qlik.com/t5/QlikView/Count-of-the-possible-values-in-Set-Analysis/m-p/34615#M776322 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P>I'd been struggling the last few days with the function p() and now I need your help. I have this formula </P><P>Count( DISTINCT {&lt;LOGISTICA_FINANCIERA_fac={'Logística'}&gt;} N_Factura_fac) where it brings me back the amount of invoices wich have a Logistic nature. The problem its within thoses invoices I also have some of them with both natures (Financial and Logistic). With a list box I select all the possible values and brings me back the amount of Logistic invoices that also have a Financial nature. How can I do this with a Set Analysis using the p() function?</P><P></P><P>Regards,</P><P></P><P>Pablo</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-of-the-possible-values-in-Set-Analysis/m-p/34615#M776322 pablomind 2020-11-25T16:16:04Z Re: Count of the possible values in Set Analysis https://community.qlik.com/t5/QlikView/Count-of-the-possible-values-in-Set-Analysis/m-p/34616#M776323 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT {&lt;N_Factura_fac = e({&lt;LOGISTICA_FINANCIERA_fac = {'Financial'}&gt;})&gt;} N_Factura_fac)</STRONG></P></BODY></HTML> Mon, 30 Apr 2018 11:16:21 GMT https://community.qlik.com/t5/QlikView/Count-of-the-possible-values-in-Set-Analysis/m-p/34616#M776323 sunny_talwar 2018-04-30T11:16:21Z