topic Re: Help with IF statement? in QlikView

Help with IF statement?

Anonymous — Wed, 17 Jun 2015 23:11:41 GMT

Hello,

I know this is a basic question but I need a little help. Can you please tell me what is wrong with my IF statement.

if([Rule Desc]='2x per node',$(vNodePercent2),

if([Rule Desc]='1 per 3 DRC',$(v1p3DRC-2),

if([Rule Desc]='10-20% per node',$(v1p3DRC-2),

if([Rule Desc]='Additional license per node',$(vAdd2)))))

Thank you,

Re: Help with IF statement?

Clever_Anjos — Wed, 17 Jun 2015 23:19:20 GMT

What kind of error are you receiving?

Re: Help with IF statement?

Anonymous — Wed, 17 Jun 2015 23:23:07 GMT

Error: Error in Expression ')' Expected

Thank you

Re: Help with IF statement?

swuehl — Wed, 17 Jun 2015 23:29:14 GMT

Have you checked that all variables expand to valid syntax?

And there is no typo in variables name?

Re: Help with IF statement?

Clever_Anjos — Wed, 17 Jun 2015 23:29:24 GMT

Weird, seems to be OK here, would you mind posting your screenshot?

Re: Help with IF statement?

Anonymous — Wed, 17 Jun 2015 23:35:18 GMT

I am not skilled at writing If statements. So I am sure its a closing bracket or something.

I was testing this in a text box. Because I want the value of the variable to show when a rules desc is showing.

Re: Help with IF statement?

Anonymous — Wed, 17 Jun 2015 23:56:50 GMT

What is -2 in $(v1p3DRC-2) and $(v1p3DRC-2) ?

Are you trying to subtract 2 from the expression?

Then try below expression

=if([Rule Desc]='2x per node',$(vNodePercent2),

if([Rule Desc]='1 per 3 DRC',$(v1p3DRC)-2,

if([Rule Desc]='10-20% per node',$(v1p3DRC)-2,

if([Rule Desc]='Additional license per node', $(vAdd2))

)

Re: Help with IF statement?

Clever_Anjos — Thu, 18 Jun 2015 00:06:19 GMT

Please take a screenshot of your Properties / Edit Expression

Re: Help with IF statement?

vardhancse — Thu, 18 Jun 2015 03:28:21 GMT

What is the value for $(v1p3DRC-2)..?

Re: Help with IF statement?

Anonymous — Thu, 18 Jun 2015 17:02:04 GMT

I found the problem. There was no data for one of the variables. I was calcuation license count inside the variable. The part number I was working with didnt have a license count.

This is working fine.

if([Rule Desc]='2x per node',$(v2x),

if([Rule Desc]='10-20% per node',$(vNodePercent2),

if([Rule Desc]='1 per 3 DRC',$(v1p3DRC-2),

if([Rule Desc]='Additional license per node',$(vAdd2)))))

How do I add another field value. I want each row to have another field selection. I also need it to be And. What is the correct syntax.

Thank you for all the help. The comments above helped me troubleshoot the problem.

:O)