Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
s33pie007
Creator
Creator

Why would the count differ

Hi everyone,

I have the following in my load script:

1.PNG

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.

The reason for joining the two together is to increase performance on the front-end.

Any help will be appreciated.

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

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:

"FCT BASKET TRN":

LOAD ...

FROM ...;

Join ([FCT BASKET TRN])

LOAD 1 As "Count Basket Trans"

Autogenerate 1;

PS - please add things like scripts as text and not as images.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein