Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

pivot table

Hello.

have a table  for Sales

CustomerSale_IDDate Sum and so on
A1...
B2...
C3...
A4...
A5...

I want to make a pivot table like this

Number of purchases per peiodNumber of customers that  have this Number of purchases per peiod
12
31

Is it possible to make this table using nly dashboard?

1 Solution

Accepted Solutions

Re: pivot table

Hi,

     You can use the dimension as below.

     Aggr(Count(Sales_Id),Cusromer)

     and expression as

     Count(Customer)

Regards,

Kaushik Solanki

10 Replies

Re: pivot table

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

ashwanin
Valued Contributor

Re: pivot table

Your requirement is possible in QV.

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

and Number of customers = count of customer.

Highlighted
Not applicable

Re: pivot table

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.

Not applicable

Re: pivot table

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

sunilkumarqv
Valued Contributor II

Re: pivot table

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

Re: pivot table

Hi,

     You can use the dimension as below.

     Aggr(Count(Sales_Id),Cusromer)

     and expression as

     Count(Customer)

Regards,

Kaushik Solanki

ashwanin
Valued Contributor

Re: pivot table

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)

ashwanin
Valued Contributor

Re: Re: pivot table

Hi,

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

Not applicable

Re: pivot table

Thank you!

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