Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

(Pending|Negotiation) Does not able to activate ?

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



15 Replies
Anil_Babu_Samineni

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)'

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
paulyeo11
Master
Master
Author

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 ?

Anil_Babu_Samineni

This will work

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
paulyeo11
Master
Master
Author

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

Anil_Babu_Samineni

No, only this

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
paulyeo11
Master
Master
Author

Thank you sir , good night and sweet dream.