topic Re: How To Calculate in Qlikview? in QlikView

How To Calculate in Qlikview?

sspawar88 — Tue, 07 Apr 2015 09:41:15 GMT

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?

Re: How To Calculate in Qlikview?

anbu1984 — Tue, 07 Apr 2015 09:45:38 GMT

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?)

Re: How To Calculate in Qlikview?

sspawar88 — Tue, 07 Apr 2015 10:09:46 GMT

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

Re: How To Calculate in Qlikview?

anbu1984 — Tue, 07 Apr 2015 10:17:18 GMT

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

Re: How To Calculate in Qlikview?

sspawar88 — Tue, 07 Apr 2015 10:19:58 GMT

anbu1984

I have reported Date Field i.e. DSR Filled

Re: How To Calculate in Qlikview?

anbu1984 — Tue, 07 Apr 2015 10:26:41 GMT

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

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

Re: How To Calculate in Qlikview?

sspawar88 — Tue, 07 Apr 2015 10:41:22 GMT

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?

Re: How To Calculate in Qlikview?

anbu1984 — Tue, 07 Apr 2015 10:45:26 GMT

May be problem in Data model