Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help in Expression

Hi,

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 .

   

Meeting IDAccountName
M01A001A
M02A001B
M03A002C
M05A003D
M06A003E
M07A004F

Thanks in advance

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

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

5 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

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))

Not applicable
Author

Hi Kavya,

what is the exact output are you expecting.

Not applicable
Author

2017-01-05_1356.png

Not applicable
Author

Hi ,

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 .

    

Meeting IDAccount IDNameCount(Account ID)
M01A001A                          2
M02A001B
M03A002C1
M05A003D                           2
M06A003E
M07A004F1
Not applicable
Author

Thanks for your response