Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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



1 Solution

Accepted Solutions
Anil_Babu_Samineni

No, only this

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

15 Replies
Anil_Babu_Samineni

May be ='(Pending|Negotiation)'

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

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 ?

Anil_Babu_Samineni

How about this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

Hi Anil

Still cannot work.

now it does not select any label.

Paul

el_aprendiz111
Specialist
Specialist

Hi,

SALESSTG.png

Anil_Babu_Samineni

PFA

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

Hi Anil

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

Initial Communication

To Initial_Communication ?

Paul Yeo

paulyeo11
Master
Master
Author

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

paulyeo11
Master
Master
Author

Hi Fer

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

Paul