Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yossi_bire
New Contributor II

Problem to create calculated field using 'if and'

Hi, I'm trying to create a calculated field in the backend mode (not a dimension) with success


if (

LINE_OF_BUSINESS ='Materials'

abd

LEDGER_CURRENCY_CODE='USA'

,'Yes','No')


any suggestion?

2 Replies

Re: Problem to create calculated field using 'if and'

May be you mis-spelled and

if (

LINE_OF_BUSINESS ='Materials'

abd

LEDGER_CURRENCY_CODE='USA'

,'Yes','No')

mdmukramali
Valued Contributor II

Re: Problem to create calculated field using 'if and'

Hi,

if (

LINE_OF_BUSINESS ='Materials'

AND

LEDGER_CURRENCY_CODE='USA'

,'Yes','No') as FieldName


Thanks,

Mukram.

Community Browser