How To Calculate in Qlikview?

[sspawar88]

Hii,

I have a Database of DSR in which fields are :

1) Reported_Date  ( On which Employee fill his own DSR )

2) Emp_ID

3) Manager_Name

4) Employee_Name

Under Particular Manager there is an number of Salesperson.

Suppose 40 (different number of Salesperson to different Manager) Salespeson belongs to one Manager.

I have two Text Object

1) DSR Filled.

2) DSR Not Filled.

When I select on one Manager & 'Reported Date' i want numbers in this two object.

Under Particular Manager How Many Employee fill his own DSR & How many are NOT?

[anbu1984]

In DSR table, do you have rows for both employees filled DSR and not filled?

How to identify employees who didn't fill DSR?( Is Reported_Date is Null?)

[sspawar88]

anbu1984‌

Not null.

if one Employee have a reported date means that employee fills DSR on that Day. Otherwise DSR not filled.

Manager_ID is associated with all Employee.

DSR Consist 210 Employee.

suppose X manager have 40 Employee.

i select on one Manager & one Reported Date.

then i need on that particular date:

1) DSR Filled

2) DSR Not Filled

[anbu1984]

So you have employees who didn't fill DSR in the table?

[sspawar88]

anbu1984

I have reported Date Field  i.e. DSR Filled

[anbu1984 · Accepted solution]

=Count(Distinct EmpId)  //Count of DSR filled

=Count(Distinct {<Reported_Date =>}EmpId) - Count(Distinct EmpId) //Count of DSR not filled

[sspawar88]

anbu1984

Actualy I tried it in one Application. it works.

But when i put it in Another Application it doesn't work.

Even all field name and set analysis is correct.

is it problem of Data Model or Another issue?

[anbu1984]

May be problem in Data model