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.
I want to display the count of accounts in text box .
If same Account is covered in 2 Meeting ID's then count is 2 and it is unique group by Meeting ID
I tried with aggr by Meeting ID .
Thanks in advance
if for each account you have only one record for each meeting
you can simply do: count(distinct [Meeting ID])
using aggr for meeting you can use
sum(aggr(count(distinct Account),Meeting ID))
View solution in original post
what is the exact output are you expecting.
I am expecting output like this.With Unique group by Meeting ID
If same account is covered in 2 meeting ID's then count is 2 .
Thanks for your response