topic Re: Syntax error on load for if statement with sum in QlikView

Syntax error on load for if statement with sum

Fri, 06 Jan 2012 12:10:20 GMT

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

Re: Syntax error on load for if statement with sum

cesaraccardi — Fri, 06 Jan 2012 13:09:46 GMT

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.

Re: Syntax error on load for if statement with sum

Fri, 06 Jan 2012 13:22:14 GMT

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