Newbie - Dates and non dates on same x-Axis

[#1]

Hi, Qlikview beginner question.

I have the following database table..

COST CENTRE	BCKLOG	SCH1	SCH2	SCH3	SCH4	SCH5
A	0	2	6	1	2	3
B	10	0	2	8	6	0
C	5	1	8	9	0	0
A	22	2	5	3	4	0
C	1	5	0	6	0	6

The BCKLOG represents the total of backdated qtys

The SCH1 in reality represents today, SCH2 represents today+1 day (ie. tomorrow), SCH3 represent today+2 days (ie. the day after tomorrow), and so on ...

I need to create a chart where the X-Axis starts with Backlog and then the dates follow, and the Y-Axis is the sum of the specific date.  So if run today the X-Axis would be, BACKLOG, 3/7, 4/7, 5/7, etc..

The cost centre would be in a list box and when I choose a particular cost centre the chart would show the relevant data for that cost centre.

With the support of this forum I managed to get the date part sorted but cannot put the backlog infront of the today's date on the x-axis.

This is the script I have at the moment...

SQL SELECT
    ITEMCODE,
    BCKLOG,
    SCH1,
    SCH2,
    SCH3,
    SCH4,
    SCH5,
    SCH6,
    SCH7
FROM BULEAS1.PMFDATA.KBOARD;

Source:
CrossTable(SCH, Value) LOAD *;
LOAD *;
SQL SELECT
    ITEMCODE,
    BCKLOG,
    SCH1,
    SCH2,
    SCH3,
    SCH4,
    SCH5,
    SCH6,
    SCH7
FROM BULEAS1.PMFDATA.KBOARD;

T:

load
[ITEMCODE],
date(Today() + right(SCH, len(SCH)-3)-1) as Date,
Value
Resident
Source;

DROP Table Source;

Any help will be appreciated.

Thanks

[Greg_Williams · Accepted solution]

Will this work?

[#3]

Thanks it does work.

Still I cannot understand how you did it.