topic Error In Expression - Syntax Error? Unable To Determine in QlikView

Error In Expression - Syntax Error? Unable To Determine

pnn44794 — Wed, 25 Nov 2020 16:16:04 GMT

Hello:

Qlikview is saying there an Error In Expression for the following expression:

=If((Approval_Year='2017', SUM(SAN))
If(Approval_Year='2017',SUM(NAS))
If(Approval_Year='2017', SUM(Backup)))

Qlikview puts a red squiggly line under the comma right after the first '2017'. I believe I have all the parentheses matched up.

What I'm trying to accomplish is to Sum the SAN, NAS or Backup values and then hopefully group them by CIO in a Bar chart. The grouping I'll worry about after getting the expression fixed, though I'm open to any suggestion on that piece too. Finished product would look similar to the following:

CIO

						Backup
Smith						NAS
						SAN


Jones



Adams


0	10	20	30	40	50

As always, any and all help is appreciated. Thanks in advance.

Re: Error In Expression - Syntax Error? Unable To Determine

vishsaggi — Fri, 07 Apr 2017 21:32:43 GMT

Try this?

= If( Approval_Year='2017', SUM(SAN),

If( Approval_Year='2017', SUM(NAS),

If(Approval_Year='2017', SUM(Backup))))

Re: Error In Expression - Syntax Error? Unable To Determine

Sat, 08 Apr 2017 08:08:28 GMT

syntax is

if (

condition, expr(),

if(

condition, expr(),

if (

condition, expr()

)

Re: Error In Expression - Syntax Error? Unable To Determine

Sat, 08 Apr 2017 08:10:33 GMT

=If(

Approval_Year='2017', SUM(SAN),
If(

Approval_Year='2017',SUM(NAS),
If(

Approval_Year='2017', SUM(Backup)

)

Re: Error In Expression - Syntax Error? Unable To Determine

Frank_Hartmann — Sat, 08 Apr 2017 08:24:29 GMT

see attached sample,

hope this helps

Re: Error In Expression - Syntax Error? Unable To Determine

Miguel_Angel_Baeyens — Sat, 08 Apr 2017 08:27:39 GMT

That expression will not work since Approval_Year is true for all three possibilities, so only the first Sum() will be calculated. Then, why not just use the Sum(Field) in three different expressions, dimension being CIO?

Re: Error In Expression - Syntax Error? Unable To Determine

sunny_talwar — Sat, 08 Apr 2017 11:03:13 GMT

You can also try set analysis

=Sum({<Approval_Year = {2017}>} SAN)

=Sum({<Approval_Year = {2017}>} NAS)

=Sum({<Approval_Year = {2017}>} Backup)

Re: Error In Expression - Syntax Error? Unable To Determine

pnn44794 — Sun, 09 Apr 2017 00:14:03 GMT

Thank you Vishwarath for your reply. I appreciate it. Your response solved the expression error, but a couple of other responses solved the whole problem. Again, thank you for replying.

Re: Error In Expression - Syntax Error? Unable To Determine

pnn44794 — Sun, 09 Apr 2017 00:18:52 GMT

Hello Frank:

Thank you for your response. I wish I could give credit for more than one correct answer, but I cannot. Your response is very close to solving the whole issue, but as it turns out, I don't need to do the Approval Year with CIO dimension. I can leave CIO as is. To be fair, it's probably due to the way my data is set up which I did not supply example of. Again, thank you very much for your response.

Re: Error In Expression - Syntax Error? Unable To Determine

pnn44794 — Sun, 09 Apr 2017 00:20:42 GMT

Thank you Miguel. I was over complicating it again. Sigh. I appreciate your help and your suggestion works perfectly. Thank you very much.

Re: Error In Expression - Syntax Error? Unable To Determine

pnn44794 — Sun, 09 Apr 2017 00:23:57 GMT

Hello Sunny:

As always, thank you for your response. You also had the correct answer and I wish I could flag more than one response as correct, but to my knowledge, I cannot do that. Your answer also works perfectly as does Miguel's. Since Miguel answered first, I felt I should mark Miguel's response as the correct one even though you have, essentially, the same responses. Again, thank you very much for taking the time to respond.