topic Re: pivot table in QlikView

pivot table

Tue, 04 Mar 2014 04:35:02 GMT

Hello.

have a table for Sales

Customer	Sale_ID	Date Sum and so on
A	1	...
B	2	...
C	3	...
A	4	...
A	5	...

I want to make a pivot table like this

Number of purchases per peiod	Number of customers that have this Number of purchases per peiod
1	2
3	1

Is it possible to make this table using nly dashboard?

Re: pivot table

MK_QSL — Tue, 04 Mar 2014 07:21:12 GMT

If you provide some data or your sample apps, we can try our best to help you on the same.

Re: pivot table

ashwanin — Tue, 04 Mar 2014 07:29:56 GMT

Your requirement is possible in QV.

Number of purchases per period= You can get it from date

and Number of customers = count of customer.

Re: pivot table

Tue, 04 Mar 2014 07:51:51 GMT

Number of purchases per period:

Customer is a Dimension,

Number of purchases is An Expression (count(Sale_Id))

After it, to get Number of customers, I need a table, where

Number of purchases is an Dimension,

Customer is an Expression (count(Customer)).

Thus Dimension becomes an Expression. That is a problem.

Re: pivot table

Tue, 04 Mar 2014 07:55:16 GMT

Thank u! But there is some data in my example.... Is it not sufficient for understanding the issue?

Re: pivot table

sunilkumarqv — Tue, 04 Mar 2014 08:00:54 GMT

Create a one more dimesion of Customer is a Dimension go to presentation column Hide that column

Re: pivot table

kaushiknsolanki — Tue, 04 Mar 2014 08:02:10 GMT

Hi,

You can use the dimension as below.

Aggr(Count(Sales_Id),Cusromer)

and expression as

Count(Customer)

Regards,

Kaushik Solanki

Re: pivot table

ashwanin — Tue, 04 Mar 2014 10:11:17 GMT

Hi Anna,

If you want to create the Pivot like the same as you have attached in the pic

then in dimension use Aggr(Count(Sale_ID),Customer) You can level the same as you required in Heading in Lebel

while in Expression use Count (Customer)

Re: Re: pivot table

ashwanin — Tue, 04 Mar 2014 12:43:50 GMT

Hi,

i have attached qv for this. it is same as you have mentioned earlier.

Re: pivot table

Tue, 04 Mar 2014 12:47:50 GMT

Thank you!

Correct answer is Aggr(Count(Sales_Id), Cusromer) and Count( distinct Customer)

Re: pivot table

Tue, 04 Mar 2014 12:51:07 GMT

Thank you, its the same whith what Kaushik.solanki has suggested