Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     You can use the dimension as below.

     Aggr(Count(Sales_Id),Cusromer)

     and expression as

     Count(Customer)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

10 Replies
MK_QSL
MVP
MVP

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

ashwanin
Specialist
Specialist

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
Author

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
Author

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

sunilkumarqv
Specialist II
Specialist II

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     You can use the dimension as below.

     Aggr(Count(Sales_Id),Cusromer)

     and expression as

     Count(Customer)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ashwanin
Specialist
Specialist

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
Specialist
Specialist

Hi,

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

Not applicable
Author

Thank you!

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