Discussion Board for collaboration on QlikView Scripting.
I encounter some issue when i notice i found that below expression when place at dimension it does not work for QV ver 9 ( it work for Ver 12 ) :-
I also consult the expert here , Mr Kri advise me my sales order table , should have only 1 field link to other table.
After check my data model on sales table , i found that most of them have only 1 field link to other table , which is correct. except for $Syn 5 which i found there are 3 field link to other table.
Am i correct to said that i should focus on remove the field that link to $Sync 5 Table , that is to remove the link on field name for SOURCE GROUP_CLASS date ?
Go to Solution.
Rename Currency field from WhatifDimension13 table
Rename GROUP_CLASS field from sales_G table
Rename date field from Supplier table
Rename GROUP_CLASS field from sales table
If you have a synthetic Key starting with $syn5, it means that you have already 5 synthetic Keys.. and you probably should remove them.
Can you attach a screen shot of your complete model ? and if you can of your script ?
Thank you for look into my question. Enclosed is my QVW.
Hi P M
I have rename those field , and now all the $Syn key missing now. All the report still able to working fine. Thank a lot.
But then i still have 2 more Syn key.
Can you share with me whcih field name from which table i need to rename ?
Enclosed my latest QVW
for first Syn key try this
INTERVALMATCH ([Reporting Code]) LOAD DISTINCT
ExecPLStart as YourFieldName,
ExecPLEnd as YourFieldName1
RESIDENT ExecProfitLoss ;
and second syn
Rename SOURCE or date field from GL_TABLE table as per your requirement
Thank you very much , After rename Intermatch table , now not more $Syn Key.
Please close this thread with marking helpful or correct. if you get answer.
I notice that after I remove the $Syn key by rename the field name for those field you recommend , after I reload I notice that it does not affect my report. Any reasons why ?
TDS Technology (S) P/L
Whatsapp +65 9326 1804