topic Re: Derive new field in QlikView

Derive new field

Anonymous — Wed, 15 Apr 2015 09:45:46 GMT

Hi ,

i have 2 fields contract term,Contract term Details.

if Contract Term is 2 Years-> In Contract Term Details -> Year 1 of 2,year 2 of 2

if Contract Term is 42 Months ->In Contract Term Details-> Month 1 of 42,Month 2 of 42 ,...........Month 42 of 42

How to achieve this

Thanks in advance

Re: Derive new field

anbu1984 — Wed, 15 Apr 2015 10:52:05 GMT

T1:
Load Distinct *,IterNo() & ' of ' & No & ' ' & Str As [Contract Term Dtls]  While IterNo() <= No;
Load Distinct [Contract Term], SubField([Contract Term],' ',1) As No,SubField([Contract Term],' ',2) As Str Resident Forecasting Order by [Contract Term];

Re: Derive new field

Anonymous — Wed, 15 Apr 2015 11:00:35 GMT

Hi Abu,

Can you post sample ,i didnt get your code

Thanks for your time

Re: Derive new field

anbu1984 — Wed, 15 Apr 2015 11:07:08 GMT

Check this app