Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
tracycrown
Contributor II

Date & Synthetics Key

Hi all

Can someone help to solve my problem on date (Jan-13) and synthetics keys (Outlet, SKU, Date ...), please refer to attached file for details  ?

Thanks Tracy

Tags (4)
1 Solution

Accepted Solutions
brindlogcool
Contributor III

Re: Re: Re: Date & Synthetics Key

Hi Tracy,

What Phaneendra given is correct.

The Fact table is getting dropped hence you are not able to see the data. I have attached the modified file for your reference.

When the tables have same column names it will automatically get concatenated in QlikView. So in your script the

1.Temp_Fact and Fact table become one table as Temp_Fact through auto concatenation(Both tables had same column name).

2. When you drop the Temp_Fact the Fact table is dropped and hence no data to display.

I just added the NoConcatenate in the script for the Fact table

Fact:

NoConcatenate

Load  Date(replace(Date,'/','-'),'DD-MM-YYYY') as Date,

Vend_Data,

SKU,

Outlet,

CKPI,

Cust_Data,

Customer,

Vendor,

VKPI

Resident Temp_Fact;

16 Replies
Partner
Partner

Re: Date & Synthetics Key

see if attached helps...

tracycrown
Contributor II

Re: Date & Synthetics Key

Dear Phaneendra

Thank you so much.

Although synthetic key has been solved, no data shown in Vendor table and the date field (41306) is different from Excel (Jan-13). Please help.

Thank you, Tracy

Partner
Partner

Re: Re: Date & Synthetics Key

see attached...

tracycrown
Contributor II

Re: Re: Date & Synthetics Key

Dear Phaneendra

Thank for your help.

When I first open your file, I saw everything on the screen and date problem had been solved.

However, when I RELOAD the file, no data appears on screen, please advise.

Thank you, Tracy

Partner
Partner

Re: Date & Synthetics Key

Are you using the same Test.Xls file that you have attached?

save your excel and my QVW in same location and perform reload.

tracycrown
Contributor II

Re: Date & Synthetics Key

Dear Phaneendra

Yes, I had done that but I also modified the followings due to my errors in original script and table :

1. Changed the script error in Customer from 5 to 4, see below:

CrossTable(Date, Cust_Data,4)

Load *.FROM

Test.xls

2. Changed Customer to Vendor

Before :  KPI, Customer, Outlet, SKU.......

After    :  KPI, Vendor, Outlet, SKU .......

Nothing shown on the screen after making above changes, please advise why this happens ?.

Thank you very much , Tracy

brindlogcool
Contributor III

Re: Date & Synthetics Key

Can you attach the modified files?

tracycrown
Contributor II

Re: Re: Date & Synthetics Key

Dear Brindlogcool

Please refer to the modified files.

Thanks, Tracy

brindlogcool
Contributor III

Re: Re: Re: Date & Synthetics Key

Hi Tracy,

What Phaneendra given is correct.

The Fact table is getting dropped hence you are not able to see the data. I have attached the modified file for your reference.

When the tables have same column names it will automatically get concatenated in QlikView. So in your script the

1.Temp_Fact and Fact table become one table as Temp_Fact through auto concatenation(Both tables had same column name).

2. When you drop the Temp_Fact the Fact table is dropped and hence no data to display.

I just added the NoConcatenate in the script for the Fact table

Fact:

NoConcatenate

Load  Date(replace(Date,'/','-'),'DD-MM-YYYY') as Date,

Vend_Data,

SKU,

Outlet,

CKPI,

Cust_Data,

Customer,

Vendor,

VKPI

Resident Temp_Fact;