If condition - script issue

gfisch13 — Fri, 15 Nov 2024 23:48:05 GMT

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

Re: If condition - script issue

Chanty4u — Thu, 15 Oct 2020 18:22:57 GMT

can you have look on this ? It might help

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

Re: If condition - script issue

Chanty4u — Thu, 15 Oct 2020 18:24:21 GMT

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

Re: If condition - script issue

gfisch13 — Fri, 16 Oct 2020 14:01:09 GMT

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

Appreciate the guidance.

Re: If condition - script issue

Chanty4u — Fri, 16 Oct 2020 14:43:09 GMT

cool it worked for you 🙂

topic Re: If condition - script issue in QlikView

If condition - script issue

Re: If condition - script issue

Re: If condition - script issue

Re: If condition - script issue

Re: If condition - script issue