Discussion Board for collaboration related to QlikView Deployment.
I've got this statement:
TABLE:LOAD BMENG AS OrderIntake ,'$(vDatum)' AS DatumFROM [some.qvd] (qvd)WHERE [Vorige datum_VDATU] = '$(vDate)'
If this date doens't exist I still want to add this date but with OrderIntake as 0.
Is this possible? If Yes how?
Thanks in advance.
Hello Rey-man,Try this code along with your existing code:
concatenate(TABLE)Load0 as OrderIntake,'$(vDatum)' as Datumfrom qvdwhere not exists([Vorige datum_VDATU],'$(vDate)');
Hope this works for you.
thanks for the reply.
Is there a way to look if it doesn't exist after some while criteria?
status must be '0000'
and organisationnumber must be 1
<pre>concatenate(TABLE)Load0 as OrderIntake,'$(vDatum)' as Datumfrom qvdwhere status = '0000'AND organisation = 1AND not exists([Vorige datum_VDATU],'$(vDate)');
I've got the solution. Maybe it can ben better, but this works.
First I've created the table with the where statements in. Next I used that table to check if a date exists.
With your Concatenate statement it works fine now.