topic Re: File Arrival Status in QlikView

File Arrival Status

Fri, 04 Jul 2014 06:15:25 GMT

Hi,

I would like to show the file arrival status in my dashboard.

Let me explain in detail, I have 7 text boxes for weekdays (Sun, Mon,Tue…) and week dimension (53 weeks).

I want to show the status based on the week selection. I will choose only one week (I don't want to select the date). I would like to show the difference in text box’s background color, means that

Green color – File has been arrived on time

Orange color – File has been arrived with delay

Red color – File hasn’t been arrived for that day

Re: File Arrival Status

tresB — Fri, 04 Jul 2014 06:42:26 GMT

What is the table structure you have? Could you post sample data?

Re: File Arrival Status

Fri, 04 Jul 2014 06:55:06 GMT

Hi,

My Table has the following colums (I have other columns also in the same table).

Week	Weekday	Date	File Arrival Status
23	3	3-Jun-14	On Time
23	4	4-Jun-14	Delay
23	5	5-Jun-14	On Time
23	6	6-Jun-14	On Time
23	7	7-Jun-14	Not Arrived
24	1	8-Jun-14	On Time
24	2	9-Jun-14	Not Arrived
24	3	10-Jun-14	On Time
24	4	11-Jun-14	On Time
24	5	12-Jun-14	Delay
24	6	13-Jun-14	On Time
24	7	14-Jun-14	On Time

Re: File Arrival Status

tresB — Fri, 04 Jul 2014 07:15:15 GMT

If you select a week - would you consider the latest date status as the week status? If so, try like:

=If(FirstSortedValue( Status, -Date) = 'On Time', green(), If(FirstSortedValue( Status, -Date) = 'Delay', RGB(250,140,100), Red()))