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: 
paulyeo11
Master
Master

My Data model $Syn 5 should be remove those 3 field ?

Hi All

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 ) :-

=IF(GROUP_CLASS='G1',COMPANY)

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 ?

remove $syn 5.png

1 Solution

Accepted Solutions
prma7799
Master III
Master III

Try this

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

View solution in original post

9 Replies
YoussefBelloum
Champion
Champion

Hi,

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 ?

paulyeo11
Master
Master
Author

Hi Youssef

Thank you for look into my question. Enclosed is my QVW.

Paul

prma7799
Master III
Master III

Try this

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

paulyeo11
Master
Master
Author

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 ?

Paul Yeo

paulyeo11
Master
Master
Author

Hi PM

Enclosed my latest QVW

prma7799
Master III
Master III

for first Syn key try this

IntervalMatch:

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

paulyeo11
Master
Master
Author

Hi PM

Thank you very much , After rename Intermatch table , now not more $Syn Key.

Paul

prma7799
Master III
Master III

Please close this thread with marking helpful or correct. if you get answer.

paulyeo11
Master
Master
Author

Hi PM

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 ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>