topic Re: let and if statement in QlikView

let and if statement

Fri, 18 Jul 2014 03:29:43 GMT

Hi, I have a 'status' variable which I derived and I want to include the status 'no job' in. And this status 'no job' is for when a variable 'time' is 0.0000. I've tried 'LET vNOJOB = 0.0000;' under a main tab in edit script and ' if((Time) = $(vNOJOB),'NO JOB' ' under another tab in edit script. However there's an error message saying ' if((Time) = $(vNOJOB),'NO JOB' ' statement takes 2-3 parameters.

Thanks.

Re: let and if statement

Fri, 18 Jul 2014 04:08:12 GMT

Hi Rachel,

I guess there should be two closing parenthesis after 'On Time', and you remove 2 after 'no job'.

As the error is describing, there's syntax error for if condition.

Re: let and if statement

PrashantSangle — Fri, 18 Jul 2014 04:23:46 GMT

Hi,

Check there is bracket need to be complete after 'On Time'

In that If statement you are taking 4 parameter.

Regards,

Re: let and if statement

PradeepReddy — Fri, 18 Jul 2014 04:24:32 GMT

Check the syntax of the IF clauses carefully.... I think it will be a minute mistake when using Nested-IF...

Re: let and if statement

PabloOrtiz — Fri, 18 Jul 2014 10:45:01 GMT

There is a syntax error, try this expression

=if(hora = $(vNOJOB),'NO JOB')

=if(hora = $(vNOJOB),'NO JOB','')

Re: let and if statement

Fri, 18 Jul 2014 11:46:51 GMT

Hi Rachel, on which place, you are using this condition ? it on LOAD or ?