topic Re: Conditional Inline Mapping in Load Script? in QlikView

Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 14:34:50 GMT

I have a field "add_date", which is a timestamp field in the database (date/time). Is there a way to create an inline table that designates any date older than 14 days as "Past Due" and those that are not as "On Track"?

Something along the lines of this for a true/false field, maybe?

LOAD

* INLINE
[
add_date, idle_request
'{>Today()-14}','1'
'{<Today()-14}','0'
]

;

Re: Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 14:38:16 GMT

Would an if statement not work rather than an inline?

If(add_date>Today()-14,1,0)

Re: Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 14:48:09 GMT

ALSO - if anyone can help me inject this condition into my existing inline table (which is used as an artificial means to sort priority), that'd be even better:

TaskPriority:

LOAD

TaskPriority,

AutoNumber(priority_name & '-' & system_name) as priorityKey;

LOAD * INLINE [

priority_name, system_name, TaskPriority

Critical, 'System Name 1', 1

Critical, 'System Name 2', 2

Critical, 'System Name 3', 3

Standard, 'System Name 1', 4

Standard, 'System Name 2', 5

Standard, 'System Name 3', 6

];

The "stale" requests would need to appear on top when sorted by task priority.

Re: Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 14:50:46 GMT

I'm not sure an if statement would work, since I need an actual field indicating whether or not a request is older than 14 days.

Re: Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 15:04:38 GMT

What should add_date be compared with? If it should compare with the day document is reloaded then Felim Shanaghy, suggesion will work as it creates a flag field in the data model.

Kiran.

Re: Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 15:25:37 GMT

Since we're looking for dates that are 14 days old, add_date needs to be compared to today's date.

Re: Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 16:29:54 GMT

try something like this:

Load *,If(add_date>Today()-14,1,0) as idle_request;
SQL SELECT * FROM TABLEX;

Kiran.

Re: Conditional Inline Mapping in Load Script?

Tue, 24 Jul 2012 18:48:32 GMT

This worked, Kiran, thanks.