Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

get count based on 2 columns

How to get count based on 2 iD's.

Coulm A     Column B

1                        aa

1                        bb

1                        cc

2                        dd

3                         ff

How to get count of columnB for each Id in Column A

Thank you much

1 Solution

Accepted Solutions
jayanttibhe
Creator III
Creator III

Sum(aggr(Count(ColumnB),ColumnA))

You can verify it in text Box  if you want to display it outside chart -

Concat(aggr(Count(Distinct [ColumnB]),ColumnA),',')

View solution in original post

6 Replies
sunny_talwar

May be add ColumnA as dimension and Count(ColumnB) as expression

jayanttibhe
Creator III
Creator III

Sum(aggr(Count(ColumnB),ColumnA))

You can verify it in text Box  if you want to display it outside chart -

Concat(aggr(Count(Distinct [ColumnB]),ColumnA),',')

View solution in original post

apthansh
Creator
Creator
Author

Thanks much.That worked.

Just wondering Count instead of Sum should also work right ?

sudeepkm
Specialist III
Specialist III

in case you want to show the Column A value along with the count of Column B per Column A  in a text object then below expression can be used.

concat(Aggr([Coulm A]&' - '&count(DISTINCT [Column B]),[Coulm A]),' | ')

output:

1 - 3 | 2 - 1 | 3 - 1
jayanttibhe
Creator III
Creator III

Yes - it depending on which aggregation function you want to use - Sum / count / min / max etc.. the outer Sum in first example is for summation of the aggregated results. You can play around it.

apthansh
Creator
Creator
Author

Thank you.