# 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
MVP

## Re: pivot table

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

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.

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?

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

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)

Highlighted
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)