Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am wondering if you can assist with, what I think is a small issue.
I have the following related QlikView "tables"
I wish to create a simple chart where the dimension is "SalesPersonName" (from the "SalesPersons" table) and the 2 expressions are:
Sales: =sum(if(OrderDate = MasterDate, SalesQty)) where "OrderDate" is the date in the Sales table (out of view above) and "MasteDate" is my date in the calendar that I use to display date choices.
Targets: =sum(if(SPTargetDate = MasterDate, SPTarget)) where "SPTargetDate" is the date in the SalesPersonsTargets table
The above works fine and I would typically get:
Salesperson | Sales | Targets |
---|---|---|
Andrew | 10 | 15 |
Ben | 20 | 22 |
Charles | 0 | 5 |
David | 11 | 0 |
Edward | 22 | 20 |
The above is OK but I want to restrict it to list SalesPersonst that have targets ONLY so "David" in the above example should not be displayed.
Anybody have any quick suggestions?
Thanx
Rok
Try doing for sales this:
If(sum(if(SPTargetDate = MasterDate, SPTarget))=0,0,sum(if(OrderDate = MasterDate, SalesQty)) )
Try doing for sales this:
If(sum(if(SPTargetDate = MasterDate, SPTarget))=0,0,sum(if(OrderDate = MasterDate, SalesQty)) )
Excellent - thanx for your help (and in record time too!)
Rok