Use created field in script

darren_dixon — Wed, 14 Aug 2013 08:41:41 GMT

Hi,

I've used an IF statement to collate the variations of Emergency into one.

I'd then like to use the newly created [Emergency Field] later in my code.

How would I do this?

if(Priority='Emergency (24h)', 'Emergency (24h)',

if(Priority='Emergency (24hr)', 'Emergency (24h)',

if(Priority='emergency 24', 'Emergency (24h)',

if(Priority='Emergency 24h', 'Emergency (24h)', 'Non-Emergency')))) AS [Emergency Status]

Re: Use created field in script

Gysbert_Wassenaar — Wed, 14 Aug 2013 08:47:36 GMT

You can do that with a preceding load.

Load

If([Emergency Status]= ''..xxx...', 1, 0) as NewEmergency

...some other fields...;

Load

if(Priority='Emergency (24h)', 'Emergency (24h)',

if(Priority='Emergency (24hr)', 'Emergency (24h)',

if(Priority='emergency 24', 'Emergency (24h)',

if(Priority='Emergency 24h', 'Emergency (24h)', 'Non-Emergency')))) AS [Emergency Status]

...some other fields...

from ...somewhere...;

The second load pipes the data into the preceding load so the new field Emergency Status is available for use in the preceding load. See this blog post for more information.

topic Re: Use created field in script in QlikView

Use created field in script

Re: Use created field in script