topic Re: Help in Expression in QlikView

Help in Expression

Wed, 25 Nov 2020 16:16:04 GMT

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 .

Thanks in advance

lironbaram — Thu, 05 Jan 2017 08:08:45 GMT

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

Thu, 05 Jan 2017 08:23:32 GMT

Hi Kavya,

what is the exact output are you expecting.

Thu, 05 Jan 2017 08:27:26 GMT

Thu, 05 Jan 2017 09:04:54 GMT

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 .

Thu, 05 Jan 2017 11:15:22 GMT

Thanks for your response