Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

if statement

it should put out R and S will display as RX and O and P as OTC.

What I I missing?

if(Dual(RxOtcInd = 'R','S', 'RX') ,(RxOtcInd= 'O','P', 'OTC'))

1 Solution

Accepted Solutions
MVP
MVP

Re: if statement

May be this:

If(Match(RxOtcInd, 'R', 'S'), 'RX',

     If(Match(RxOtcInd, 'O', 'P'), 'OTC'))

1 Reply
MVP
MVP

Re: if statement

May be this:

If(Match(RxOtcInd, 'R', 'S'), 'RX',

     If(Match(RxOtcInd, 'O', 'P'), 'OTC'))