Discussion Board for collaboration related to QlikView App Development.
I have a table with data looks like below. I want to display in a separate pivot table how many are meeting the targets per agent per region.
A selection input box is made available to select the target. 50000, 100000, 200000
Using Pivot Table I want to display how may are meeting the sales target based on the selected variable value.
Selected Value : 50000
Condition: Total Sales should be >= 50000 to meet the target:
Select Value : 100000
Condition : Total Sales shoud be >= 100000
I tried Sum and Count function combinations in the expression but to no avail.
Any help is highly appreciated.
What you need is some AGGR(). Code may need a little tweaking since I'm typing it in directly here and not into a Qlik engine...
Count(AGGR(Sum(SalesAmount),Region,Agent, Year, Month)>$(vSalesTarget))
View solution in original post
Thanks for the help.
I tweaked it, and below is the one working to meet my requirements.
SUM(FABS(Aggr(DISTINCT SUM(SalesAmount), Region, Agent) > $(vSalesTarget)))