Discussion board where members can get started with QlikView.
[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 ?
Go to Solution.
Have you tried without the sum?
if(today()-[Date the error was discovered]=20,upper([Customer name])) as [CPC 20 Error Name]
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