This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
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.