topic Re: Pick(Wildmatch(GetFieldSelections requires help in QlikView

Pick(Wildmatch(GetFieldSelections requires help

helen_pip — Wed, 16 Aug 2017 11:00:37 GMT

Dear Qlikview user

I have a button which if the user clicks on, I want the text in another text object to say "Good" otherwise "Bad"

My expression is as follows, but I cannot seem to get the "Bad" wording to appear:

Pick(WildMatch(GetFieldSelections(ED_Mode_of_Arrival_Category),'*Helicopter*'),'Good','Bad')

Can anyone help me with this technqiue

In addition my original expression was an If statement, but thought a Pick(Wildmatch would be more efficient, but if an IF is O.K. t use then I will scrap the idea of a Pick(Wildmatch(

Any help would be greatly appreciated

Thanks

Helen

Re: Pick(Wildmatch(GetFieldSelections requires help

Anil_Babu_Samineni — Wed, 16 Aug 2017 11:02:02 GMT

Where are you doing this?

Re: Pick(Wildmatch(GetFieldSelections requires help

helen_pip — Wed, 16 Aug 2017 11:03:53 GMT

Hello

I am doing this in a text object at front end

Thanks

Helen

Re: Pick(Wildmatch(GetFieldSelections requires help

prma7799 — Wed, 16 Aug 2017 11:05:47 GMT

Try like this

=if((Pick(WildMatch(GetFieldSelections(ED_Mode_of_Arrival_Category),'*Helicopter*'))),'Good' , 'Bad')

Re: Pick(Wildmatch(GetFieldSelections requires help

Anonymous — Wed, 16 Aug 2017 11:07:23 GMT

wildmatch for the false path will return 0, but your pick() statement expects 2 for false

Re: Pick(Wildmatch(GetFieldSelections requires help

Anonymous — Wed, 16 Aug 2017 11:08:09 GMT

but then pick is useless or?

Re: Pick(Wildmatch(GetFieldSelections requires help

helen_pip — Wed, 16 Aug 2017 11:09:59 GMT

It would seem pick is useless on this instance. I am working on the Wildmatch option now!

I.e.

WildMatch(GetFieldSelections(ED_Mode_of_Arrival_Category),'*Helicopter*','Good','Bad')

Thanks

Helen

Re: Pick(Wildmatch(GetFieldSelections requires help

Anonymous — Wed, 16 Aug 2017 11:12:42 GMT

no you need the if()!

Re: Pick(Wildmatch(GetFieldSelections requires help

helen_pip — Wed, 16 Aug 2017 11:16:40 GMT

The following expression works:

If(WildMatch(GetFieldSelections(ED_Mode_of_Arrival_Category),'*Helicopter*'), 'Good', 'Bad')

However I am using Wildmatch to replace the original expression(Below) as I had hoped Wildmatch would be more effiecient than "like":

=If(GetFieldSelections(ED_Mode_of_Arrival_Category) Like '*Helicopter*',

"Good"

"Bad"

)

I would ideally like to remove the IF statement completely if this improves efficiency

Kind Regards

Helen

Re: Pick(Wildmatch(GetFieldSelections requires help

Anil_Babu_Samineni — Wed, 16 Aug 2017 11:19:27 GMT

Does Bad is not working for you?

Re: Pick(Wildmatch(GetFieldSelections requires help

helen_pip — Wed, 16 Aug 2017 11:22:50 GMT

Hello Anil

I have got the expression to work as follows:

If(WildMatch(GetFieldSelections(ED_Mode_of_Arrival_Category),'*Helicopter*'), 'Good', 'Bad')

I had hoped to remove the If completely if it is inefficient, as the purpose of this exercise is to improve efficiency in some of my expressions

I opted for WildMatch as the original expression was:

=If(GetFieldSelections(ED_Mode_of_Arrival_Category) Like '*Helicopter*',

'Good',

'Bad'

)

Do you know whether my opting for Wildmatch is better then using If and Like

Kind Regards

Helen

Re: Pick(Wildmatch(GetFieldSelections requires help

Anonymous — Wed, 16 Aug 2017 11:25:01 GMT

you want to check getfieldselections which returns 1 value against '*Helicopter*' ?

I don't understand what you're trying to optimize?

I think that caculation will be done once per selection...

Re: Pick(Wildmatch(GetFieldSelections requires help

Anil_Babu_Samineni — Wed, 16 Aug 2017 11:26:10 GMT

Try this?

=Pick(WildMatch(GetFieldSelections(ED_Mode_of_Arrival_Category), '*Helicopter*') + 1, 'Bad' , 'Good')