Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
HenriqueCaps
Contributor
Contributor

2 conditions IF

Hi everyone.

At first, im trying to use a if almost like this...

If(
    MODULO = 'IMPO',

      PORTO_X,

          IF(

              MODULO='EXPO',

                   PORTO_Y,

                        iF( MODULO = '("IMPO"|"EXPO")'

                                PORTO_X

)))

 

 

 

sOMETHING LIKE THIS.Ç.. BUT WHEN I FILTER THEY 2 (EXPO AND IMPO) it doenst do it right... 

Labels (3)
1 Reply
jochem_zw
Partner Ambassador
Partner Ambassador

try something like this: 

If(Modulo='IMPO'
    ,'PORTO_X'
    ,IF(Modulo='EXPO'
        ,'PORTO_Y'
        ,If(GetFieldSelections(Modulo,'|') = 'EXPO|IMPO'
            ,'PORTO_X')))