topic Re: Two Period date for One Line Chart in QlikView

Two Period date for One Line Chart

jumiprado — Thu, 21 Jul 2016 20:06:50 GMT

Hi!

I need some help for this. I have the following tables

Client	Process ID	Bill Date	Bill Money
10001-0	58	Jul - 05 - 2016	200
10111-2	2	Jun - 17 - 2016	300
30451-2	1	May - 25 -2016	150
10111-2	3	jul - 17 - 2016	300

Client	Process ID	Collection Date	Collection Money
10001-0	58	Jul - 25 - 2016	200
10111-2	2	Jul - 01 - 2016	300
30451-2	1	Jun - 10 -2016	150
10111-2	3	jul - 27 - 2016	300

I need to make a table where i can see if the Client have been billed and Collected. If the money collected was the total for the Billed Money.

I think that if I concatenate CLIENT with PROCESS ID maybe i can relate the tables. Please help me with this!

Thanks you!

Re: Two Period date for One Line Chart

sunny_talwar — Thu, 21 Jul 2016 20:30:16 GMT

Why don't you join them instead of Concatenating them:

Table:

LOAD Client,

[Process ID],

[Bill Date],

[Bill Money]

FROM .....;

Join (Table)

LOAD Client,

[Process ID],

[Collection Date],

[Collection Money]

FROM .....;

This will put them side by side making the overall comparison easy to do.

Re: Two Period date for One Line Chart

sravanthialuval — Mon, 02 Jan 2017 09:46:19 GMT

But it will form synthetic keys using Client and process ID.

Sunny T <span class="icon-status-icon icon-mvp" title="Mvp"></span> wrote:

Why don't you join them instead of Concatenating them:

Table:

LOAD Client,

          [Process ID],

          [Bill Date],

          [Bill Money]

FROM .....;

Join (Table)

LOAD Client,

          [Process ID],

          [Collection Date],

          [Collection Money]

FROM .....;

This will put them side by side making the overall comparison easy to do.

Try this

table1:

LOAD Client&' '&[Process ID] as clientprocessid,

Client,

[Process ID],

[Bill Date],

[Bill Money]

FROM

(biff, embedded labels, table is Sheet1$);

table2:

LOAD Client&' '&[Process ID] as clientprocessid,

[Collection Date],

[Collection Money]

FROM

(biff, embedded labels, table is Sheet2$);

Re: Two Period date for One Line Chart

sunny_talwar — Mon, 02 Jan 2017 13:21:25 GMT

How is join going to create a synthetic key?