Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

senpradip007
Valued Contributor III

Pivot Table Problem

Hi

Today I need a help from you.

I've a Pivot table named Chart and its property named prop..

I want to count customer with respect to Sales Group and I'm using =Count(Customer) as expression. It shows 36 instead of 4.

Can anyone help me out of this problem?

Thanks in advanced.


2 Replies
manideep78
Valued Contributor

Re: Pivot Table Problem

Use this Expression

Aggr(Count(Customer),Sales_Group)

You will get count of customers accordning to Sales_Group wise.

Hope it helps

senpradip007
Valued Contributor III

Re: Pivot Table Problem

Hi Manideep,

Thanks for reply.

According to your expression, it calculates the right result when I select only one Sales_Group, it calculates nothing when nothing selected or more than one Sales_Group selected..

What can I do?