Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you copy paste the whole script as text rather than an image?
Can you explain what the business logic is behing this mass of braces? That may make translation into QlikView easier...
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")))))
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.
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
Hi Thanks for the reply. I have using first code of you provided.. after that i am facing
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',
Is there any chance to share application with sample data
Hi,
Can you please tell me how can i share my application.
There is no option in this discussion