Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this and let me know
=IF(postrulecode='0450' OR assetstatus='INTRAY','under Construction','ASSET')
if( postrulecode='0450' or Assetstatus = 'intray','under Construction','ASSET')
try this and let me know
=IF(postrulecode='0450' OR assetstatus='INTRAY','under Construction','ASSET')
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.
Check your data, the condition must work ... let me know
Hi,
Can you post sample data to look over?
Regards
ASHFAQ
If this is the case then it may be that you have spaces in your data.
Try using trim(postrulecode) in your expression
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.
Hi,
I cannot download document its corrupted.
Can you attach it again.
Regards
ASHFAQ