Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Valued Contributor

Re: Syntax error on load for if statement with sum

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.

2 Replies
cesaraccardi
Valued Contributor

Re: Syntax error on load for if statement with sum

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

Re: Syntax error on load for if statement with sum

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