I am not an expert at all with Qlikview, but I have been assigned to solve something:
Let's say I have a database like this (bigger, with way more fields and thousand's of records):
|Juan||MIGRACION PROD. P&C|
|Martin||ERROR DE EMISION|
I am creating a table in the front, and for one of the fields, I am trying to create an expression that:
-if MOTIVO_BAJA is not null and also if MOTIVO_BAJA is different than "RENOVACION" or MIGRACION PROD. P&C" then show a number 1...
-And if MOTIVO_BAJA is null or is equal to RENOVACION or MIGRACION PROD. P&C then show a 0.
I tried with this one, but it didn't work:
IF(IsNull(MOTIVO_BAJA),0,IF(MOTIVO_BAJA<>"RENOVACION" or "MIGRACION PROD. P&C"),1,0)
That option worked pretty good: (It was the other way, 0 for renovacion, migracion.., " - ", and 1 for the others.
So I wrote it : if(Match(MOTIVO_BAJA, 'RENOVACION',' [MIGRACION PROD. P&C]','-') ), 0,1)
The only problem now is that in the cases where MOTIVO_BAJA is null, it shows number 1, and its supposed to show a 0 value. Its not taking it as " - " in the expression script.
Do you have any idea why that could be happening ?
Thank you so much !