topic Why would the count differ in QlikView https://community.qlik.com/t5/QlikView/Why-would-the-count-differ/m-p/959871#M953570 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hi everyone,</P><P style="text-align: left;"></P><P style="text-align: left;">I have the following in my load script:</P><P style="text-align: left;"></P><P style="text-align: left;"><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106365_1.PNG" style="height: 314px; width: 620px;" /></P><P style="text-align: left;"></P><P style="text-align: left;">Now what I would like to do is to join the Count Basket Trans table to FCT BASKET TRN, but as soon as I do that, my counts differ.</P><P style="text-align: left;"></P><P style="text-align: left;">The reason for joining the two together is to increase performance on the front-end.</P><P style="text-align: left;"></P><P style="text-align: left;">Any help will be appreciated.</P></BODY></HTML> Mon, 23 Nov 2015 06:34:46 GMT Anonymous 2015-11-23T06:34:46Z Why would the count differ https://community.qlik.com/t5/QlikView/Why-would-the-count-differ/m-p/959871#M953570 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hi everyone,</P><P style="text-align: left;"></P><P style="text-align: left;">I have the following in my load script:</P><P style="text-align: left;"></P><P style="text-align: left;"><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/106365_1.PNG" style="height: 314px; width: 620px;" /></P><P style="text-align: left;"></P><P style="text-align: left;">Now what I would like to do is to join the Count Basket Trans table to FCT BASKET TRN, but as soon as I do that, my counts differ.</P><P style="text-align: left;"></P><P style="text-align: left;">The reason for joining the two together is to increase performance on the front-end.</P><P style="text-align: left;"></P><P style="text-align: left;">Any help will be appreciated.</P></BODY></HTML> Mon, 23 Nov 2015 06:34:46 GMT https://community.qlik.com/t5/QlikView/Why-would-the-count-differ/m-p/959871#M953570 Anonymous 2015-11-23T06:34:46Z Re: Why would the count differ https://community.qlik.com/t5/QlikView/Why-would-the-count-differ/m-p/959872#M953571 <HTML><HEAD></HEAD><BODY><P>I am not sure what exactly you are trying to do, but if all you want to do is add a counter field with a value of 1 to the first table, then just join like this:</P><P></P><P><EM>"FCT BASKET TRN":</EM></P><P><EM>LOAD ...</EM></P><P><EM>FROM ...;</EM></P><P></P><P><EM>Join ([<SPAN style="font-size: 13.3333px;">FCT BASKET TRN])</SPAN></EM></P><P><SPAN style="font-size: 13.3333px;"><EM>LOAD 1 As "Count Basket Trans"</EM></SPAN></P><P><SPAN style="font-size: 13.3333px;"><EM>Autogenerate 1;</EM></SPAN></P><P></P><P>PS - please add things like scripts as text and not as images.</P></BODY></HTML> Mon, 23 Nov 2015 06:44:31 GMT https://community.qlik.com/t5/QlikView/Why-would-the-count-differ/m-p/959872#M953571 jonathandienst 2015-11-23T06:44:31Z