topic Re: if or if statement in qlikview in QlikView

if or if statement in qlikview

Mon, 17 Nov 2014 12:36:52 GMT

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

Re: if or if statement in qlikview

ali_hijazi — Mon, 17 Nov 2014 12:39:12 GMT

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

Re: if or if statement in qlikview

alexandros17 — Mon, 17 Nov 2014 12:39:13 GMT

try this and let me know

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

Re: if or if statement in qlikview

Mon, 17 Nov 2014 12:47:53 GMT

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.

Re: if or if statement in qlikview

alexandros17 — Mon, 17 Nov 2014 12:53:27 GMT

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

Re: if or if statement in qlikview

ashfaq_haseeb — Mon, 17 Nov 2014 12:55:12 GMT

Hi,

Can you post sample data to look over?

Regards

ASHFAQ

Re: if or if statement in qlikview

marcus_malinow — Mon, 17 Nov 2014 12:56:39 GMT

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

Try using trim(postrulecode) in your expression

Re: Re: if or if statement in qlikview

Mon, 17 Nov 2014 13:23:15 GMT

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.

Re: if or if statement in qlikview

ashfaq_haseeb — Mon, 17 Nov 2014 13:26:36 GMT

Hi,

I cannot download document its corrupted.

Can you attach it again.

Regards

ASHFAQ