Simple selection question

[#1]

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

[#2 · Accepted solution]

Try doing for sales this:

If(sum(if(SPTargetDate = MasterDate, SPTarget))=0,0,sum(if(OrderDate = MasterDate, SalesQty)) )

[#3]

Excellent - thanx for your help (and in record time too!)

Rok