Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Creator III
Creator III

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

1 Solution

Accepted Solutions
brindlogcool
Creator III
Creator III

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;

View solution in original post

16 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

see if attached helps...

tracycrown
Creator III
Creator III
Author

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

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

see attached...

tracycrown
Creator III
Creator III
Author

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

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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
Creator III
Creator III
Author

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
Creator III
Creator III

Can you attach the modified files?

tracycrown
Creator III
Creator III
Author

Dear Brindlogcool

Please refer to the modified files.

Thanks, Tracy

brindlogcool
Creator III
Creator III

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;