topic Re: aggregation result in QlikView

aggregation result

Wed, 25 Nov 2020 16:16:04 GMT

How can I show count of aggregatad results??

I have a dimension employee

and

expression Sum(worked hrs)

now I want to count aggregated result in other expression irrespective of any selection.

1st expression Sum(worked hrs)

and In my 2nd expression

It is something like that count(Sum(worked hrs))

any help??

Regards,

Bab Tech

Re: aggregation result

Anil_Babu_Samineni — Wed, 25 Jan 2017 04:36:59 GMT

Try this?

Count(aggr(sum([Worked Hrs]),Employee))

Re: aggregation result

tresB — Wed, 25 Jan 2017 05:03:22 GMT

Not sure if understood right.

If you have n employees, you would be getting n number of aggregations. That is if you want to count the number of aggregations - that would be eventually distinct number of employees which you can get using count(Distinct employee). If you want to get the total number against all the employee rows, you might have to use count(Distinct TOTAL employee).

Re: aggregation result

Anonymous — Wed, 25 Jan 2017 05:46:12 GMT

Hi Babi,

Can you pls share some sample data so we can work on that . Currently its difficult for me to understand your requirement.

Thanks,

Pooja