topic Re: (Pending|Negotiation) Does not able to activate ? in QlikView

(Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 14:52:11 GMT

Hi All

I need to create a button , when i activate , i need the Pending & Negotiation label to be turn on.

So i using below script :-

(Pending|Negotiation)

But it does not work. Can some one advise me why ?

Paul

Re: (Pending|Negotiation) Does not able to activate ?

Anil_Babu_Samineni — Wed, 17 Jan 2018 15:01:59 GMT

May be ='(Pending|Negotiation)'

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:08:11 GMT

Hi Anil

Thank you.it work fine, like below :-

='(Pending|Negotiation|Prospecting)'

But i also have :-

Initial Communication

='(Pending|Negotiation|Prospecting|[Initial Communication])'

Above does not work. why ?

Re: (Pending|Negotiation) Does not able to activate ?

Anil_Babu_Samineni — Wed, 17 Jan 2018 15:15:02 GMT

How about this?

='(' & Concat(DISTINCT {<[Sales Stage] = {'Pending', 'Negotiation', 'Initial Communication'}>}Chr(34) & [Sales Stage] & Chr(34), '|') & ')'

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:18:20 GMT

Hi Anil

Still cannot work.

now it does not select any label.

Paul

Re: (Pending|Negotiation) Does not able to activate ?

el_aprendiz111 — Wed, 17 Jan 2018 15:19:54 GMT

Hi,

Re: (Pending|Negotiation) Does not able to activate ?

Anil_Babu_Samineni — Wed, 17 Jan 2018 15:20:51 GMT

PFA

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:21:25 GMT

Hi Anil

How about can you advise me how to recode the label of

Initial Communication

To Initial_Communication ?

Paul Yeo

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:24:27 GMT

Hi Anil

I think your is latest ver.

I open your QVW , it still not working.

May be due to I am still using Ver 9 , no budget to upgrade.

Paul

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:26:09 GMT

Hi Fer

Thank you , i am using ver 9 , not able to work.

Paul

Re: (Pending|Negotiation) Does not able to activate ?

Anil_Babu_Samineni — Wed, 17 Jan 2018 15:29:32 GMT

Finally, You are here.

Pick(Match([Sales Stage],'Initial Communication')+1,[Sales Stage],'Initial_Communication') as [Sales Stage],

Reload after that to your field instead [Sales Stage]

Then, Search string looks ='(Pending|Negotiation|Initial_Communication)'

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:34:47 GMT

Hi Anil

Your work , but when i add one more label , it does not work :-

Pick(Match(

[Sales Stage],'Initial Communication')+1,[Sales Stage],'Initial_Communication')

[Sales Stage],'Needs Assessment')+1,[Sales Stage],'Needs_Assessment')

as [Sales Stage_],

Why ?

Re: (Pending|Negotiation) Does not able to activate ?

Anil_Babu_Samineni — Wed, 17 Jan 2018 15:39:30 GMT

This will work

Replace([Sales Stage],' ','_') as [Sales Stage]

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:42:31 GMT

Hi Anil,

Do you mean :-

Pick(Match(

[Sales Stage],'Initial Communication')+1,[Sales Stage],'Initial_Communication')

[Sales Stage],'Needs Assessment')+1,[Sales Stage],'Needs_Assessment')

Replace([Sales Stage],' ','_') as [Sales Stage1],

I try , it does not work.

Paul

Re: (Pending|Negotiation) Does not able to activate ?

Anil_Babu_Samineni — Wed, 17 Jan 2018 15:44:27 GMT

No, only this

Replace([Sales Stage],' ','_') as [Sales Stage]

Re: (Pending|Negotiation) Does not able to activate ?

paulyeo11 — Wed, 17 Jan 2018 15:46:58 GMT

Thank you sir , good night and sweet dream.