Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?