topic Re: Logic Requirement in QlikView

Logic Requirement

aveeeeeee7en — Wed, 23 Apr 2014 11:51:19 GMT

Hi Community

I have a requirement.

See the Attachment.

Regards

Aviral

its_anandrjs — Wed, 23 Apr 2014 12:05:06 GMT

How you calculate the

New Field Requiremrnt

what is the logic for that.

Roop — Wed, 23 Apr 2014 13:06:04 GMT

The key to this is to reverse the order and this then produces what you require:

Staff:

LOAD

Joining,

Leaving,

MOB,

date#('01 ' & CommonMonth & ' ' & CommonYear, 'DD MMM YY') as DateValue,

CommonMonth,

CommonYear

FROM [Logic Requirement.xlsx]

(ooxml, embedded labels, table is Sheet1) ;

NewStaff:

Load *,

if(RecNo() = 1,

MOB,

NumSum(MOB, Peek(CumMOB)) - Previous(Joining) + Previous(Leaving)

) as CumMOB

resident Joiners

order by DateValue desc;

Drop Table Staff;

Hope this helps

aveeeeeee7en — Wed, 23 Apr 2014 16:48:48 GMT

Thanks Rupert

It is giving me desired Output.

When I am applying your logic in my Application it is not Working?

I don't know why this is happening....

Roop — Thu, 24 Apr 2014 09:49:36 GMT

This is the table that I am using and it works exactly as specified. I hope it helps

Roop — Thu, 24 Apr 2014 09:54:30 GMT

This is a copy of the output: