topic Re: How to replace the below logic in QlikView

How to replace the below logic

Anonymous — Wed, 24 Jan 2018 09:04:29 GMT

=if(match([Meeting Type],'1X1','1X1*','2X1','3X1','GRP','CCL'),[Meeting Type])

how to replace the 'GRP', is a 'group meeting' and 'CCL' is 'Conference Cal'

Re: How to replace the below logic

Anil_Babu_Samineni — Wed, 24 Jan 2018 09:14:19 GMT

You have opened many threads, And not yet solve even you haven't look back from there. So, I would suggest you to get all thing which you need. Don't thread be alone.

Anyway, Where are you trying this? In Script / UI??

Re: How to replace the below logic

Anonymous — Wed, 24 Jan 2018 09:18:53 GMT

Hi Anil

Script only..

Thanks,

Re: How to replace the below logic

Anil_Babu_Samineni — Wed, 24 Jan 2018 09:23:59 GMT

From give statement, there is two times loading involved. If you provide any application we will work out for you?

Re: How to replace the below logic

Anonymous — Wed, 24 Jan 2018 11:44:56 GMT

Hi Anil,

I traied below expresion but it's not working

if(match([Meeting Type],'1X1','1X1*','2X1','3X1','GRP','CCL'),Replace(Replace(Replace([Meeting Type],'GRP','Group Meeting'),'CCL','Conference Call'),'1X1*','1X1'))) ,[Meeting Type]

thanks,

Re: How to replace the below logic

sunny_talwar — Wed, 24 Jan 2018 12:09:58 GMT

Why can't you just do this?

=If(Match([Meeting Type],'1X1','1X1*','2X1','3X1','group meeting','Conference Cal'),[Meeting Type])

Re: How to replace the below logic

Anonymous — Wed, 24 Jan 2018 12:20:08 GMT

Hi Sunny

The below expresion 'GRP' replace with 'Group Metting'

and 'CCL' Replace with 'Conference Cal and '1X1*''

replace with '1X1'

if(match([Meeting Type],'1X1','1X1*','2X1','3X1','GRP','CCL'),

o/p

1X1

2X1

3X1

Group Meeting

Conference Cal

Thanks,

Re: How to replace the below logic

sunny_talwar — Wed, 24 Jan 2018 12:25:12 GMT

Before we help you any further, do you promise to close all your previous non-closed threads

Re: How to replace the below logic

Anonymous — Wed, 24 Jan 2018 12:28:57 GMT

Can you guide me how to close threads really i don't know

Re: How to replace the below logic

sunny_talwar — Wed, 24 Jan 2018 12:30:42 GMT

Sure, look here

Qlik Community Tip: Marking Replies as Correct or Helpful

You need to mark Correct Answer for the answer that best fit your needs. and you can mark any helpful responses for things you found helpful.

Re: How to replace the below logic

Anonymous — Wed, 24 Jan 2018 13:37:47 GMT

tell me the exactly expression.

Thanks