Discussion Board for collaboration related to Creating Analytics for QlikView.
have a table for Sales
I want to make a pivot table like this
Is it possible to make this table using nly dashboard?
Go to Solution.
You can use the dimension as below.
and expression as
If you provide some data or your sample apps, we can try our best to help you on the same.
Your requirement is possible in QV.
Number of purchases per period= You can get it from date
and Number of customers = count of customer.
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.
Thank u! But there is some data in my example.... Is it not sufficient for understanding the issue?
Create a one more dimesion of Customer is a Dimension go to presentation column Hide that column
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)
i have attached qv for this. it is same as you have mentioned earlier.
Correct answer is Aggr(Count(Sales_Id), Cusromer) and Count( distinct Customer)