How to Make Target Sales and Actual Sales in the same Period dimension

[apradity]

Hello,

I'm relatively new to qliksense.

I have been dealing with issues of how to make Target Sales and Actual Sales in the same time period dimensions.

So I have about 6 tables.

2 of them are fact tables i  guess:

1. actual sales table (which contains field Year Month as a time period) and the actual sales of each outlet

2. target sales table (which contains also field YearMonth as a time period) and the target sales

Both connects to a calendar table with the field YearMonth as an association.

But qliksense wants me to delete one of the field of YearMonth because it creates a circular reference.

If I delete the YearMonth field in target table, it will cause in the graph I cannot view them side by side because the target table now doesn't have a field YearMonth.

I tried link tables, but it even creates more synthkeys. Is there any solution on this?

Should I join the target and actual sales table and separate both facts with another field named "Version" which contains "sales actual" and "sales target"?

[Yoshidaqlik]

Hi

You can concatenate tables with the same names by creating a field to differentiate them in sums.

Example:

Table_All:
Load
...
...
Date_real as Date_1
YearMonth as YearMonth_1
'Table_real' as id_Table 
value as value_1
...
From ...

concatenate(Table_All)
Load
...
...
Date_fcs as Date_1
YearMonth_fcs as YearMonth_1
'Table_fcs' as id_Table 
value_fcs as value_1
...
From ...

In Meansures you can differentiate this way

real:
sum({<table_id={'table_real'}>} value_1)

FCS:
sum({<table_id={'table_fcs'}>} value_1)

Regards

[apradity]

Hi Yoshida,

Thanks a lot.

I already done concatenate manually by merging them together in excel and create a new field to differentiate "Actual" and "Target" sales.

I will try your solution by doing this in the data load editor.

Thanks a lot Yoshida