topic Re: Getfieldselections with multiple values in if condition in QlikView

Getfieldselections with multiple values in if condition

innashna — Sat, 16 Nov 2024 03:55:25 GMT

Hello,

I need to build condition where image is getting replaced only if two particular values are selected.

When only one value had to be selected I used :

(IF(Match(GetFieldSelections([DD_Solution_Leg_SOLUTION_NAME]),'EVPL', 'EDI','ENS','EPL'),'qmem://image name/Metro_E' )

Now there is a requirement to present image Metro_E when the following logic acts:

match (DD_Solution_Leg_SOLUTION_NAME,'EVPL','EDI','ENS','EPL') and match (DD_Solution_Leg_SOLUTION_NAME,'Business Internet')

How I use this condition in the GetFields Selection function?

Thanks,

Inna

Re: Getfieldselections with multiple values in if condition

sunny_talwar — Mon, 08 Apr 2019 12:15:40 GMT

Is this saying that DD_Solution_Leg_SOLUTION_NAME is either one of the following ('EVPL','EDI','ENS','EPL') and in addition 'Business Internet' is also selected?

Re: Getfieldselections with multiple values in if condition

innashna — Mon, 08 Apr 2019 12:19:06 GMT

Yes

Re: Getfieldselections with multiple values in if condition

sunny_talwar — Mon, 08 Apr 2019 12:21:41 GMT

What if the user select 3 values

1) EVPL

2) ENS

3) Business Internet

Would you still want to show the image or not?

Re: Getfieldselections with multiple values in if condition

innashna — Mon, 08 Apr 2019 12:26:06 GMT

Yes.

Re: Getfieldselections with multiple values in if condition

sunny_talwar — Mon, 08 Apr 2019 12:33:58 GMT

May be this

If((
SubStringCount('|' & GetFieldSelections([DD_Solution_Leg_SOLUTION_NAME], '|') & '|', '|EVPL|') = 1 or
SubStringCount('|' & GetFieldSelections([DD_Solution_Leg_SOLUTION_NAME], '|') & '|', '|EDI|') = 1 or
SubStringCount('|' & GetFieldSelections([DD_Solution_Leg_SOLUTION_NAME], '|') & '|', '|ENS|') = 1 or
SubStringCount('|' & GetFieldSelections([DD_Solution_Leg_SOLUTION_NAME], '|') & '|', '|EPL|') = 1
)
and
(
SubStringCount('|' & GetFieldSelections([DD_Solution_Leg_SOLUTION_NAME], '|') & '|', '|Business Internet|') = 1
), 'qmem://image name/Metro_E')

Re: Getfieldselections with multiple values in if condition

innashna — Mon, 08 Apr 2019 12:57:06 GMT

Works!! Genius!!!Thanks!!