Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
dogu19
Contributor
Contributor

distinct count

Hi,

I have a distinct count issue.

I have three condition:

1) I want to count distinct column A

2) I want to count values in column B

3) I want to filter -for example ("IR", "TIR")- values in column C

Count({<[C]= {"IR", "TIR"}>}[B]) --> but this formula should count my values with respect to "Distinct A" --> How can I complete this formula

 

Thanks

3 Replies
MatheusC
Specialist
Specialist

Olá, poderia tentar isso Contagem ({<[C] = {"IR", "TIR"}>} distinto [A], [B])

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
dogu19
Contributor
Contributor
Author

Hi,

It didn't work. I got error: "Count takes 1 parameter"

ManuelRühl
Partner - Specialist
Partner - Specialist

Could you provide a simple example?

Manuel Rühl
www.mamaconsulting.de