Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Im trying to create a document that will only select a field when it matches a certain valua's how ever he selects the valuas from differnt tables. So far so simple to do this i created to follow IF statement.
=IF(Todo.FK_WORKFLOWSTATE ='43EA659F-14BB-473A-869B-819C63EF43AC'
AND Inboundmessages.FK_WORKFLOWSTATE = '6E490B26-35EF-41F3-97FB-68E5E2DB1344'
AND APPOINTMENTS.FK_WORKFLOWSTATE ='43EA659F-14BB-473A-869B-819C63EF43AC' , actionscope.code)
How ever i also need to the select actionscope.code when 1 of them matches and the other are not present(null). Or when 2 match and the other is not present ect.
Anyhelp or surgestions??
Regards
Luuk
I finaly managed to get it to work this morning quite simple.
I used this as IF
if($(vAfsprakencounter)+$(vTodocounter)+$(vMessagecounter) = $(vMessagedone)+$(vTododone)+$(vAppointmentsdone), 'Done', 'Open')
I edited my script to also load a list of completed fields and when this sum matches it show me if everything has been completed or no. Not minding that some value's are 0.
can't you work with extra ()'s?
like
IF( (statement from above) OR (additional statement) OR (additional statement) ) etc
This is a option yes how ever i dont know how i tell qlikview to load it in the right way
I have 3 tables with different records with a status field, i need to load all files when they are all done or one when the others are null. like this :
a Done b Done c Done, <---Load it here
a Done b Null c Done, < ---- Load here
a Done B not ready c Done <---- Don't Load
How ever i dont know how i create a statement like this.
I finaly managed to get it to work this morning quite simple.
I used this as IF
if($(vAfsprakencounter)+$(vTodocounter)+$(vMessagecounter) = $(vMessagedone)+$(vTododone)+$(vAppointmentsdone), 'Done', 'Open')
I edited my script to also load a list of completed fields and when this sum matches it show me if everything has been completed or no. Not minding that some value's are 0.