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

[Anil_Babu_Samineni]

Here you go

Uploading a Sample

[Peter_Cammaert]

You can still edit your original question in this discussion by selecting the Edit item in the Actions menu in the top right corner. Then follow the instructions in Anil's linked article.

You don't need to create a new thread as this will be confusing to posters and no real question is being asked in the second thread. Please remove it from the forum and post your attachments in your original quesiton at the top. Thanks.

[#4]

Hi How can i remove forum..

Can you guide me

[Anil_Babu_Samineni]

Here you go for Peter Suggestion

[#6]

Hi Anil

I need to implement below formula also

can you please help me

=IF([@[Source Type]=114,"EBO",IF([@[Source Type]]=115,"Listed",IF(OR([@[Source Type]]=105, [@[Source Type]]=32,[@[Source Type]]=45, [@[Source Type]]=142,[@[Source Type]]=147, [@[Source Type]]=87,[@[Source Type]]=162), "FI",IF(OR([@[Source Type]]=132, [@[Source Type]]=32,[@[Source Type]]=27, [@[Source Type]]=182,[@[Source Type]]=157), "Active",IF(OR([@[Source Type]]= 28,[@[Source Type]]=72,[@[Source Type]]=97, [@[Source Type]]=172,[@[Source Type]]=72, [@[Source Type]]=167),"Passive",IF(OR([@[Source Type]]=0, [@[Source Type]]=1,[@[Source Type]]=2), “HV”,[@[part Type]]))))))

[Anil_Babu_Samineni]

This is straight forward, In Qlik you can use this

IF([@[Source Type]=114,"EBO",

IF([@[Source Type]]=115,"Listed",

IF([@[Source Type]]=105 or [@[Source Type]]=32 or [@[Source Type]]=45 or [@[Source Type]]=142 or [@[Source Type]]=147 or [@[Source Type]]=87 or [@[Source Type]]=162, "FI",

IF([@[Source Type]]=132 or [@[Source Type]]=32 or [@[Source Type]]=27 or  [@[Source Type]]=182 or [@[Source Type]]=157), "Active",

IF([@[Source Type]]= 28 or [@[Source Type]]=72 or [@[Source Type]]=97 or [@[Source Type]]=172 or [@[Source Type]]=72 or [@[Source Type]]=167),"Passive",

IF([@[Source Type]]=0 or [@[Source Type]]=1 or [@[Source Type]]=2, “HV”,[@[part Type]]))))))

FYI ...

This will work as like image. In Qlik it work as If(Color = 'Green' or Color = 'Red', 'TRUE', 'FALSE')

[#8]

Hi,

Thanks for reply.

I am using this code. After that i getting the following error

in that above code we have given a close braces on 152) and 167) . when ever reload the script i getting  above scrren shot error.

[Peter_Cammaert]

In the Actions menu underneath "Edit" and "Move", there is a "Delete" button. Press that one.

Maybe you should take some time to do a quick read of Qlik Community Tip: How to Delete a Post

And fo a long-running discussion like this: Qlik Community Tip: Marking Replies as Correct or Helpful

[Anil_Babu_Samineni]

Seems, issue here. check Red text and then remove that it will work

IF([@[Source Type]=114,"EBO",

IF([@[Source Type]]=115,"Listed",

IF([@[Source Type]]=105 or [@[Source Type]]=32 or [@[Source Type]]=45 or [@[Source Type]]=142 or [@[Source Type]]=147 or [@[Source Type]]=87 or [@[Source Type]]=162, "FI",

IF([@[Source Type]]=132 or [@[Source Type]]=32 or [@[Source Type]]=27 or  [@[Source Type]]=182 or [@[Source Type]]=157), "Active",

IF([@[Source Type]]= 28 or [@[Source Type]]=72 or [@[Source Type]]=97 or [@[Source Type]]=172 or [@[Source Type]]=72 or [@[Source Type]]=167),"Passive",

IF([@[Source Type]]=0 or [@[Source Type]]=1 or [@[Source Type]]=2, “HV”,[@[part Type]]))))))

[Peter_Cammaert]

In the first line, there is one right square bracket missing in the field name as well...

IF([@[Source Type]]=114,"EBO",

: