Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
see if attached helps...
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
see attached...
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
Are you using the same Test.Xls file that you have attached?
save your excel and my QVW in same location and perform reload.
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
Can you attach the modified files?
Dear Brindlogcool
Please refer to the modified files.
Thanks, Tracy
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;