Implement Excel Formula in QlikView

[#1]

Hi this is a excel formula, i want to implement  in qlikview..

So kindly help me..

Thanks in advance..

Note: Edited by Community Moderator for clarity

[vishsaggi]

Can you copy paste the whole script as text rather than an image?

[Peter_Cammaert]

Can you explain what the business logic is behing this mass of braces? That may make translation into QlikView easier...

[#4]

By using this formula i need to create a new field in qlikview. i.e., Product or etc.. (This is already implemented in excel)

=IF(OR(isnumber(search("P3",[@[Statuses]])),isnumber(search("C6",[@[Statuses]]))),"Pending",IF(OR(isnumber(search("P6",[@[Statuses]])),isnumber(search("C12",[@[Statuses]])),isnumber(search("C14",[@[Statuses]])),isnumber(search("C18",[@[Statuses]])),isnumber(search("C19",[@[Statuses]]))),"Repair",IF(OR(isnumber(search("C4",[@[Statuses]])),isnumber(search("P8",[@[Statuses]]))),"Dormant",IF(OR(isnumber(search("P7",[@[Statuses]])),isnumber(search("P9",[@[Statuses]]))),"Reportable Ind",IF(OR(isnumber(search("C8",[@[Statuses]])),isnumber(search("C9",[@[Statuses]])),isnumber(search("C13",[@[Statuses]])),isnumber(search("C20",[@[Statuses]])),isnumber(search("C21",[@[Statuses]])),isnumber(search("C22",[@[Statuses]]))),"Reportable ENT","Non-Reportable")))))

[Anil_Babu_Samineni]

Formula is more sufficient to reply, It would better if you provide what you are expecting and at least business. So then we can understand easily what they want in simpler way by  help of Qlik.

[Anil_Babu_Samineni · Accepted solution]

May be this?

If(IsNum(SubStringCount([@[Statuses]],'P3') or IsNum(SubStringCount([@[Statuses]],'C6')), 'Pending',

If(IsNum(SubStringCount([@[Statuses]],'P6') or IsNum(SubStringCount([@[Statuses]],'C12') or IsNum(SubStringCount([@[Statuses]],'C14') or IsNum(SubStringCount([@[Statuses]],'C18') or IsNum(SubStringCount([@[Statuses]],'C19')), 'Repair',

If(IsNum(SubStringCount([@[Statuses]],'C3') or IsNum(SubStringCount([@[Statuses]],'P8')), 'Dormant',

If(IsNum(SubStringCount([@[Statuses]],'P7') or IsNum(SubStringCount([@[Statuses]],'P9')), 'Reportable Ind',

If(IsNum(SubStringCount([@[Statuses]],'C8') or IsNum(SubStringCount([@[Statuses]],'C9') or IsNum(SubStringCount([@[Statuses]],'C13') or IsNum(SubStringCount([@[Statuses]],'C20') or IsNum(SubStringCount([@[Statuses]],'C21') or IsNum(SubStringCount([@[Statuses]],'C22')), 'Reportable ENT', 'Non-Reportable')))))

Or This? By using IsNum function instead of IsNumber in qlikview

If(WildMatch([@[Statuses]],'P3*') or WildMatch([@[Statuses]],'C6*'), 'Pending',

If(WildMatch([@[Statuses]],'P6*') or WildMatch([@[Statuses]],'C12*') or WildMatch([@[Statuses]],'C14*') or WildMatch([@[Statuses]],'C18*') or WildMatch([@[Statuses]],'C19*'), 'Repair',

If(WildMatch([@[Statuses]],'C3*') or WildMatch([@[Statuses]],'P8*'), 'Dormant',

If(WildMatch([@[Statuses]],'P7*') or WildMatch([@[Statuses]],'P9*'), 'Reportable Ind',

If(WildMatch([@[Statuses]],'C8*') or WildMatch([@[Statuses]],'C9*') or WildMatch([@[Statuses]],'C13*') or WildMatch([@[Statuses]],'C20*') or WildMatch([@[Statuses]],'C21*') or WildMatch([@[Statuses]],'C22*'), 'Reportable ENT', 'Non-Reportable')))))

Or you can add haiku(*) before of the search string as well

[#7]

Hi Thanks for the reply. I have using first code of you provided.. after that i am facing

[#8]

Hi nagaraju, I have using first code as your provided. when ever loading that i am facing below error

IF(isnum(SubStringCount([Statuses],'P3')) OR (isnum(SubStringCount([Statuses],'C6')),'Succ

i.e., IF(isnum(SubStringCount([Statuses],'P3')) OR (isnum(SubStringCount([Statuses],'C6')),'Success',

[Anil_Babu_Samineni]

Is there any chance to share application with sample data

[#10]

Hi,

Can you please tell me how can i share my application.

There is no option in this discussion