Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table with two fields with unlinked dimension

I need to create a pivot table which analyze the customer actions. The table will be weekly basis and should give me the number of customers that sign up at the corresponding week. In addition to that, I want to see how many transactions were made at that corresponding week. The problem is that there is no link between the login date,which doesn't always mean a transaction, of a customer and transaction date in the model.


The pivot table should look like this.



Week(Login Date)
2013/052013/062013/07
new member number
Orders



Really glad if you help me. I can give more information if something is not clear.

Thanks.

3 Replies
Not applicable
Author

Please post sample data with ur QVW

Not applicable
Author

Hi,

I prepared a small qvw which tells my problem basically. You can see that I connect two tables with the customer id. I want to create a table which counts the number of customers and sales but their date fields are not connected. If I connect the date fields my data model will be broken in my other analysis. How can I create this kind of pivot table? Can I use set analysis for this situation.

Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand