topic Re: Comparing sum further within dimension in QlikView

Comparing sum further within dimension

Tue, 19 Feb 2013 12:40:13 GMT

I have pivot table

UserName Sum(Planed) Sum(Actual) in thir column I want the number of count of Dr whose Sum(Planed) <=Sum(Actual)

how can I achieve this.. sample files are attached

thanks in advance.

manideep78 — Tue, 19 Feb 2013 13:09:45 GMT

Hi,

I didn't understood what you said exactly. Could you please explain clearly or else provide some sample output according to your requirement?

Tue, 19 Feb 2013 16:16:27 GMT

Thanks for reply...

sample out put of pivot table

User No_Of_FullyAttended_Doctors

Khalid 1

for only one Dr B the condition sum(planed) <= sum(actual) is true.

or in other words i need count of Dr where Sum(Planed) - Sum(Actual) <=0

jagannalla — Tue, 19 Feb 2013 16:59:34 GMT

Hello,

Try this expression for fully visited.

=Count(If(Aggr(Sum(Planed),Dr)<=Aggr(Sum(Actual),Dr),Dr))

Hope it helps you.

Cheers!!

Jagan Nalla

Tue, 19 Feb 2013 17:33:57 GMT

Thanks a lot it worked:)