Discussion board where members can get started with QlikView.
How to get count based on 2 iD's.
Coulm A Column B
How to get count of columnB for each Id in Column A
Thank you much
Go to Solution.
You can verify it in text Box if you want to display it outside chart -
View solution in original post
May be add ColumnA as dimension and Count(ColumnB) as expression
Thanks much.That worked.
Just wondering Count instead of Sum should also work right ?
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]),' | ')
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.