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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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.