Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax error on load for if statement with sum

Hi Guys

if(sum(today()-[Date the Error was discovered])= '20',upper([Customer Name])) as

[CPC 20 Error Name]

As a work around for an Alert - I need to create a field made up of specific customer names.

I am trying to take the date an error was discovered and count how many days it is open ( By minusing it from todays date !!) if this is equal to 20 then creating a field called

[CPC 20 Error Name] that contains the names that was in Customer name,

I keep getting a syntax error on load , I think its how I have written the sum formula -- Can anyone please help ?

Thanks

A

1 Solution

Accepted Solutions
cesaraccardi
Specialist
Specialist

Hi Blossomthe2nd,

Have you tried without the sum?

if(today()-[Date the error was discovered]=20,upper([Customer name])) as [CPC 20 Error Name]

Regards,

Cesar.

View solution in original post

2 Replies
cesaraccardi
Specialist
Specialist

Hi Blossomthe2nd,

Have you tried without the sum?

if(today()-[Date the error was discovered]=20,upper([Customer name])) as [CPC 20 Error Name]

Regards,

Cesar.

Not applicable
Author

Hi Cesar,

Duel issue , I actually took out the "From" part of the script in error ,

I got a different load error and used your sugeestion , and its A Ok now

Thanks

A