Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Derive new field

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

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

3 Replies
anbu1984
Master III
Master III

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];

Anonymous
Not applicable
Author

Hi Abu,

Can you post sample ,i didnt get your code

Thanks for your time

anbu1984
Master III
Master III

Check this app