topic contract term Default to 3 Years in QlikView

contract term Default to 3 Years

Anonymous — Fri, 08 May 2015 08:06:02 GMT

Hi Guru's,

I have contract Term,Contract term Details fields

if contract term =3 years,in contract term details -Year 1 of 3

Year 2 of 3

year 3 of 3 like that

in contract term i have fields Like One "Off","Other","perpetual","TBD"

but i want to make 3 years as Default contract year if any field found like "Other","perpetual","TBD"

how to achieve this.

please find the sample application as attached

Thanks in advance

Re: contract term Default to 3 Years

sunilkumarqv — Fri, 08 May 2015 08:15:50 GMT

Write it in script

in preceding load

Load *,

if(match([Contract term], 'Other','perpetual','TBD'),If([Contract term details],'3 year',Contract term)) as [Contract term]

LOad * from data source

Re: contract term Default to 3 Years

Anonymous — Fri, 08 May 2015 08:27:41 GMT

can u do it in sample ,iam un able to achieve result

Thanks in advance. take application as binary it will work

Thanks in advance

Re: contract term Default to 3 Years

CELAMBARASAN — Fri, 08 May 2015 09:01:10 GMT

Change this if Statement

If(WildMatch([Contract Term], '*Months*'), Ceil(KeepChar([Contract Term],0123456789)/12), If(MixMatch([Contract Term], 'Other','perpetual','TBD'),3, Num(KeepChar([Contract Term],0123456789)))) as MaxNum,

Re: contract term Default to 3 Years

Anonymous — Fri, 08 May 2015 11:07:11 GMT

hi celambarasan,

thanks for your time

other than Other','perpetual','TBD i have blanks in contract Term

how to pull those

thanks inadvance

Re: contract term Default to 3 Years

Anonymous — Fri, 08 May 2015 11:47:04 GMT

for blank contract terms also default i would show 3 Year

Re: contract term Default to 3 Years

CELAMBARASAN — Fri, 08 May 2015 12:22:15 GMT

May be this would help you

If(WildMatch([Contract Term], '*Months*'), Ceil(KeepChar([Contract Term],0123456789)/12), If(Num(KeepChar([Contract Term],0123456789)), Num(KeepChar([Contract Term],0123456789)),3)) as MaxNum