Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
innashna
Contributor II
Contributor II

Put Multiple Values in layout condiiton for Getfields function

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

Labels (3)
1 Reply
gf
Creator III
Creator III

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'))