topic Complex IF Statement. in QlikView

Complex IF Statement.

Wed, 08 Dec 2010 15:44:50 GMT

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

Complex IF Statement.

amien — Wed, 08 Dec 2010 15:53:01 GMT

can't you work with extra ()'s?

IF( (statement from above) OR (additional statement) OR (additional statement) ) etc

Complex IF Statement.

Wed, 08 Dec 2010 17:12:49 GMT

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.

Complex IF Statement.

Thu, 09 Dec 2010 10:23:30 GMT

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.