Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
Try this expression for fully visited.
Hope it helps you.
I didn't understood what you said exactly. Could you please explain clearly or else provide some sample output according to your requirement?
Thanks for reply...
sample out put of pivot table
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
Thanks a lot it worked