This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
New to ClikView so sorry if this question is answered multiple places elsewhere! I've looked through the reference and developer guide and don't see a clear answer to this:
I have a customer table: Has a customer ID field.
I have a second table with sales transactional data that has 3 references back to the customer table: customer that ordered, customer that was charged, and customer that product was shipped to.
As I understand it I make associations between the tables by naming fields identically. So my question is do I:
A. Load the Customer table 3 times and each time rename the customer ID field?
B. Load the Customer table 1 time with the Customer ID field listed 3 times with different names ([Customer ID] AS [Ship Cust ID], [Customer ID] AS [Charge Cust ID], [Customer ID] as [Order Cust ID])
C. Some other advanced feature I haven't yet discovered?
I'm guessing option B but was wondering if anyone else had any thoughts on this?
I depends on your goals.
Since you have common list of customers for all transactions it seems that your 'Ship', 'Charge', 'Order' analytics belongs to transactional essense.
I think you can Load your Customer table one time with [Customer ID].
Then you can transform your transactional data so that they use only [Customer ID] as reference.
Finally, to keep your 'Ship', 'Charge', 'Order' analytics create separate field fo that in transactional data.
You should load the customer table three times using different field names. See more on my blog: