Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

Count of the possible values in Set Analysis

Hi everybody,

I'd been struggling the last few days with the function p() and now I need your help. I have this formula

Count( DISTINCT {<LOGISTICA_FINANCIERA_fac={'Logística'}>} 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?

Regards,

Pablo

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(DISTINCT {<N_Factura_fac = e({<LOGISTICA_FINANCIERA_fac = {'Financial'}>})>} N_Factura_fac)

View solution in original post

1 Reply
sunny_talwar

May be this

Count(DISTINCT {<N_Factura_fac = e({<LOGISTICA_FINANCIERA_fac = {'Financial'}>})>} N_Factura_fac)