Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pnn44794
Partner - Specialist
Partner - Specialist

Error In Expression - Syntax Error? Unable To Determine

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
01020304050

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

10 Replies
pnn44794
Partner - Specialist
Partner - Specialist
Author

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.