Discussion board where members can get started with Qlik Sense.
I have a customer table like:
A sales table like:
I want to create a pivot table with dimensions: ItemCategory-rep-customer-sales, which should be like:
How should I create the model?
Join both the tables.
or use concatenate function loading merge both the tables.
Please pick necessary columns from second table like below:
Load * Inline [
Customer, Rep, ItemCateogory
You will get your desired output