Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

(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
loveisfail
Not applicable

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

No, only this

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

Life is so rich, and we need to respect to the life !!!
15 Replies
loveisfail
Not applicable

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

May be ='(Pending|Negotiation)'

Life is so rich, and we need to respect to the life !!!
paulyeo11
Not applicable

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

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 ?

loveisfail
Not applicable

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

How about this?

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

Life is so rich, and we need to respect to the life !!!
paulyeo11
Not applicable

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

Hi Anil

Still cannot work.

now it does not select any label.

Paul

el_aprendiz111
Not applicable

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

Hi,

SALESSTG.png

loveisfail
Not applicable

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

PFA

Life is so rich, and we need to respect to the life !!!
paulyeo11
Not applicable

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

Hi Anil

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

Initial Communication

To Initial_Communication ?

Paul Yeo

paulyeo11
Not applicable

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

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
Not applicable

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

Hi Fer

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

Paul