Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

pivot table question

I have a pivot table with dimensions: FoodType, Salesrep, SalesArea, Customer, and measure: count(VISIT).

There are only 2 FoodTypes: Apple and Banana. The pivot table is like:

333.PNG

But for the same rep-area-customer, I want count(VISIT) to be the same for Apple and Banana. Should be like:

444.PNG

What function should I use?

Thank you very very much!!!

1 Solution

Accepted Solutions
kkkumar82
Valued Contributor III

Re: pivot table question

How about

Sum(Total <Salesrep, SalesArea, Customer> Visit) ?

10 Replies
thi_pham
Contributor

Re: pivot table question

Let try: Count (total <FoodType> visit)

wanyunyang
Contributor

Re: pivot table question

Then count(VISIT) for A, B, C will be the same.

ogautier62
Valued Contributor II

Re: pivot table question

Hi,

and what about prior post ?

for this one you must use aggr :

aggr(sum(Visit),Customer)

please close threads, or tell what is wrong

thanks

wanyunyang
Contributor

Re: pivot table question

Hi,

Gave it a go with sum(aggr(count(Visit),Customer)), but numbers for different FoodType are different.

ogautier62
Valued Contributor II

Re: pivot table question

so yes :

you must use aggr on the customer dimension (because it's not dimension of chart)

and use sum() on the other dimension because you want dimension of chart

use as expression :

if(dimensionality() = 'the dimensionality of cust dim',

         aggr(count(Visit),Customer),

         count(Visit)    )

first add dimensionality() as expression in your chart to see which is one of customer and supress after

pablolabbe
Valued Contributor II

Re: pivot table question

Don't forget !


When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

kkkumar82
Valued Contributor III

Re: pivot table question

How about

Sum(Total <Salesrep, SalesArea, Customer> Visit) ?

wanyunyang
Contributor

Re: pivot table question

Hi Olivier, thanks for help, but it's not working. The numbers are the same as count(Visit).

wanyunyang
Contributor

Re: pivot table question

It works!! Thank you so much!!

Community Browser