topic Re: Finding Pending Docs in QlikView

Finding Pending Docs

jyothish8807 — Mon, 29 Apr 2013 06:31:52 GMT

Hi,

I was trying to create a field ,but got stuck with a particular condition,plz help me in that.

Scenario is something this.

Suppose a teacher is supposed to check 100 answer sheet in 5 Days. So his daily target will be 20 ( 100/5).

But if he checks only 18 on theday then on a Field Named "Pending" it should show "2" and his next day target should automatically update to "22" instead of 20.

How can i create the pending field. it shuld keep on updating as per the dates i select. So, what i cant is my daily target shold automatically updated as per the date iam selecting.

Name	Actual Done	Daily target	weekly target	Pending
aaa	18	20	100	2
aaa	20	22	100	2
aaa	18	22	100	4
aaa	24	24	100	0

regards

Jyothish KC

Re: Finding Pending Docs

kaushiknsolanki — Mon, 29 Apr 2013 07:27:27 GMT

Hi,

Its better if you share sample data, to give us more clarification on what data you have.

Regards,

Kaushik Solanki

Re: Finding Pending Docs

Mon, 29 Apr 2013 07:27:33 GMT

use INPUTFIELD for dynamically update the data.

syntax:

INPUTFIELD a;

load a,

from table;

then on pivote table, field a add as expression add clik on any data to modify the value.

then on this modification other fields automatically updated..

Re: Finding Pending Docs

Mon, 29 Apr 2013 09:06:41 GMT

Try this (see attached). I have used the above function

Re: Finding Pending Docs

jyothish8807 — Wed, 01 May 2013 12:49:34 GMT

Can you please explain this line:

if(len(20 - aggr(above(sum([Actual Done])),Name,RowNo) + 20) = 0, 20, 20 - aggr(above(sum([Actual Done])),Name,RowNo) + 20)

Regards

Jyothish KC