topic Re: Synthetic key and ''ghost'' field in QlikView https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670972#M243783 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Your cross table load is set to 6 attribute fields, but your load statement only has 5, so the cross table is using the January field as another attribute. You will see there is field named [41275]. Change the cross table statement to </P><P></P><P>CrossTable(MONTH, Actual, <STRONG>5</STRONG>)</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Wed, 22 Oct 2014 07:31:02 GMT jonathandienst 2014-10-22T07:31:02Z Synthetic key and ''ghost'' field https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670969#M243780 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>A newbie is seeking for your guidance.</P><P>I am facing the following issue:</P><P></P><P>I have a synthetic table made of another synthetic table. Despite this mess, app seems to work properly (99%). Any ideas on how to make it better and dissolve any clouds and fears that the app might now be working properly?</P><P></P><P>In addition, in my source table in excel I have values for the field January 2013. (Jan 2013) but it does not show in my app, resulting in slight decline on the desired totals..</P><P></P><P>Please note that I do not have a programming background so excuse my clumsy approach to the scripting part.</P><P></P><P>Find attached a reduce/scrambled app.</P><P></P><P>Thank you for your help</P></BODY></HTML> Tue, 21 Oct 2014 14:44:00 GMT https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670969#M243780 2014-10-21T14:44:00Z Re: Synthetic key and ''ghost'' field https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670970#M243781 <HTML><HEAD></HEAD><BODY><P>The script doesn't match your data model. In the script you concatenate the data from ActualLY with Actual and then drop ActualLY. But in the table viewer the table ActualLY exists. The same with some fields you dropped. The data you loaded cannot be the result of the script in your document. If that script were used you wouldn't have a table ActualLY and no $Syn3 Table.</P></BODY></HTML> Tue, 21 Oct 2014 19:37:31 GMT https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670970#M243781 Gysbert_Wassenaar 2014-10-21T19:37:31Z Re: Synthetic key and ''ghost'' field https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670971#M243782 <HTML><HEAD></HEAD><BODY><P>Lets assume that the problem with the $SYn3 table is fixed</P><P>I will give you another example regarding the "ghost" field section&nbsp; without synthetic keys and $syntables (I am attaching the relevant app).</P><P></P><P>Why QV does not show (and therefore calculate) January 2013&nbsp; (41275 I think) despite appearing in the script ? </P><P></P><P>January is messing with my head!</P><P></P><P>Thank you for your help!</P></BODY></HTML> Wed, 22 Oct 2014 07:08:18 GMT https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670971#M243782 2014-10-22T07:08:18Z Re: Synthetic key and ''ghost'' field https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670972#M243783 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Your cross table load is set to 6 attribute fields, but your load statement only has 5, so the cross table is using the January field as another attribute. You will see there is field named [41275]. Change the cross table statement to </P><P></P><P>CrossTable(MONTH, Actual, <STRONG>5</STRONG>)</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Wed, 22 Oct 2014 07:31:02 GMT https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670972#M243783 jonathandienst 2014-10-22T07:31:02Z Re: Synthetic key and ''ghost'' field https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670973#M243784 <HTML><HEAD></HEAD><BODY><P>Thanks a million !</P></BODY></HTML> Wed, 22 Oct 2014 07:35:00 GMT https://community.qlik.com/t5/QlikView/Synthetic-key-and-ghost-field/m-p/670973#M243784 2014-10-22T07:35:00Z