Put Multiple Values in layout condiiton for Getfields function

innashna — Sat, 16 Nov 2024 03:55:22 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: Put Multiple Values in layout condiiton for Getfields function

gf — Tue, 09 Apr 2019 05:53:56 GMT

Try it like this:
=If(Match(GetFieldSelections(DD_Solution_Leg_SOLUTION_NAME),'EVPL', 'EDI','ENS','EPL'),'qmem://image name/Metro_E' ,if(Match(GetFieldSelections(DD_Solution_Leg_SOLUTION_NAME),'EVPL','EDI','ENS','EPL') AND Match(GetFieldSelections(DD_Solution_Leg_SOLUTION_NAME),'Business Internet'),'yourSecondImage','defaultImage'))

topic Put Multiple Values in layout condiiton for Getfields function in QlikView

Put Multiple Values in layout condiiton for Getfields function

Re: Put Multiple Values in layout condiiton for Getfields function