If condition - script issue

[gfisch13]

Hi - I'm loading data from a spreadsheet source and trying to create a field called bucket where records are classified as:

• Under 30,
• 31-60,
• 61-120,
• Greater than 120.

The attached script (to preserve color) continues to throw an error indicating the the expression is missing a ")" (closing parenthesis).  I've also listed the script below, the section in question is highlighted in orange.

I cannot seem to understand where this should be placed.  Open to any comments/suggestions.

Thanks, George

LOAD Location,
     [Case Number (Fraud ID)],
     [Date Reported],
     [Date Investigation Started],
     [Amount at Risk/Detected Fraud (USD)],
     [Subject of Investigation],
     [Case Contact],
     [Product/Claim Type],
     [Case Type],
     [Coverage Type],
     [Internal/ External],
     [Case Details],
     [Action Taken],
     [Amount of Recovered Fraud (USD)],
     [Amount of Prevented Fraud (USD)],
     [Case Investigation Status],
     [Date Investigation Closed],
     [Fraud Type],
     [Case Age (Days)],
     [Net Loss (USD)],
     [Opened Period],
     [Closed Period],
       IF ([Case Age (Days)] <= 30, Dual('Less than 30', 1),
              IF ([Case Age (Days)] => 31 and [Case Age (Days)] <= 60, Dual('30-60', 2),
              IF ([Case Age (Days)] => 61 and [Case Age (Days)] <= 120, Dual('61-120', 3),
              IF ([Case Age (Days)] => 121, Dual('Greater than 120', 4))))) as Buckets,
     Confidential
FROM

[Chanty4u · Accepted solution]

Hi 

can you have  look on this ? It might help 

https://community.qlik.com/t5/QlikView-App-Development/If-Condition/td-p/1364702

[Chanty4u]

Or try to create those bucket in before load statement only ? Did you tried that ?

[gfisch13]

Thank you, this is a great guide, and I also learned that I had inverted my => and should have been >=.

Appreciate the guidance.

[Chanty4u]

cool it worked for you 🙂