Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


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.

Valued Contributor III

Pivot Table Problem


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
Valued Contributor

Re: Pivot Table Problem

Use this Expression


You will get count of customers accordning to Sales_Group wise.

Hope it helps

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?