Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
OnurT
Contributor II
Contributor II

aggregation 2 Columns

OnurT_0-1664444114173.png

Hi,

I want to make column A1 count.

A2 is singular and A3 is ="car".

 

count({<[A1]>}, [A3]="Car" and distinct [A2])

 

Thank you

Labels (1)
3 Replies
sidhiq91
Specialist II
Specialist II

@OnurT  Your requirement seems to be pretty straight forward.

Dim: A2, A3

Measure: Count(Distinct A1)

OnurT
Contributor II
Contributor II
Author

The formula I wrote did not work, I would appreciate it if you could write an example.

sidhiq91
Specialist II
Specialist II

@OnurT  Can you please provide me the sample data?