QlikView App Dev

[joshi_qlikview]

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

[sunilkumarqv]

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

[joshi_qlikview]

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

[CELAMBARASAN]

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,   

[joshi_qlikview]

hi celambarasan,

thanks for your time

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

how  to pull those 

thanks inadvance

[joshi_qlikview]

for blank contract terms also default i would show 3  Year

[CELAMBARASAN · Accepted solution]

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