if or if statement in qlikview

[#1]

Hello everybody,

i have a (for me) difficult issue.

I have two dimension fields (postrulecode and assetstatus) with infos and want to create a third dimension (constructionstatus) which is dependent on the both before.

=IF(postrulecode='0450','under Construction',

OR
IF(assetstatus='INTRAY','under Construction',

//[ELSE]

'ASSET'))

What is wrong in this formular?

Very much thanks in advance

[ali_hijazi]

if( postrulecode='0450' or Assetstatus = 'intray','under Construction','ASSET')

[alexandros17 · Accepted solution]

try this and let me know

=IF(postrulecode='0450' OR  assetstatus='INTRAY','under Construction','ASSET')

[#4]

Wow that answer was quick. Thanks.

I think it is not completely correct, because for the line with postrulecode = 0450, I get 'ASSET' as result.

So it seems that qlikview ignores the first condition.

[alexandros17]

Check your data, the condition must work ... let me know

[ashfaq_haseeb]

Hi,

Can you post sample data to look over?

Regards

ASHFAQ

[marcus_malinow]

If this is the case then it may be that you have spaces in your data.

Try using trim(postrulecode) in your expression

[#8]

Hi please find attached an example.

The last two lines are Assets under construction. If you open right sight you will see as postrulecode '0450' in the last line.

Hope you'll find the mistake.

[ashfaq_haseeb]

Hi,

I cannot download document its corrupted.

Can you attach it again.

Regards

ASHFAQ