Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.