1

I have 2 different expression in qlikview and i want to use these both expression at in 1 measure

first expression 

=if(P_No_1=SubField([P No.],'-',1), 'Renew','Lost')

second expression 

=If(Len(Old_Policy)=0 and Year(Today())=[Year], 'New' )

now i am trying to use these 2 expression at one time only .. how i do this any help beacuse whatever the result came from both expression i want it into 1 column ..

how i do this

MIRROR
  • 61
  • 1
  • 2
  • 10

1 Answers1

0

You can nest the if statements

if(Len(Old_Policy)=0 and Year(Today())=[Year], 'New' , if(P_No_1=SubField([P No.],'-',1), 'Renew','Lost'))

The Budac
  • 1,571
  • 1
  • 8
  • 10