Discussion board where members can get started with QlikView.
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?
Solved! Go to Solution.
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:
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.
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.