Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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"

mruehl
Partner - Specialist
Partner - Specialist

Could you provide a simple example?