Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Model creation

I have a customer table like:

111.PNG

A sales table like:

222.PNG

I want to create a pivot table with dimensions: ItemCategory-rep-customer-sales, which should be like:

333.PNG

How should I create the model?

2 Replies
rangam_s
Contributor II

Re: Model creation

Join both the tables.

or use concatenate function loading merge both the tables.

arvind_patil
Valued Contributor II

Re: Model creation

Dear Wanyun,

Please pick necessary columns from second table like below:

Cust:

Load * Inline [

Customer, Rep, ItemCateogory

1,A,a

2,B,b

3,C,a

];

Sales:

Load * Inline [

Customer,  Sales

1,400

2,300

];

Exit Script;

O/p,


You will get your desired output

https://community.qlik.com/servlet/JiveServlet/showImage/2-1505841-205951/333.PNG

Thanks,

Arvind Patil

Community Browser