Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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
Honored Contributor III

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

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

9 Replies
YoussefBelloum
Esteemed Contributor

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

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
Valued Contributor II

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

Hi Youssef

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

Paul

prma7799
Honored Contributor III

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

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
Valued Contributor II

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

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
Valued Contributor II

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

Hi PM

Enclosed my latest QVW

prma7799
Honored Contributor III

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

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
Valued Contributor II

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

Hi PM

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

Paul

prma7799
Honored Contributor III

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

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

paulyeo11
Valued Contributor II

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

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>

Community Browser