Simple selection question

Fri, 09 Dec 2011 14:34:47 GMT

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

Simple selection question

Fri, 09 Dec 2011 14:44:01 GMT

Try doing for sales this:

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

Re: Simple selection question

Fri, 09 Dec 2011 16:10:25 GMT

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

Rok

topic Simple selection question in QlikView

Simple selection question

Simple selection question

Re: Simple selection question