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.

bibopipo
Contributor II

problem with count

Dear all,

I'm a bit confused. I've a Customer Masterdata table. I 've to produce a simple graph like this:

Total customer 2000

Customer from CRM   500  25%

Pending customers    100    5%

Customer without Sales orders  200  10%

and so on..

How can I do it ?

Thanks in advance for your help

2 Replies
Not applicable

Re: problem with count

Hi,

If you use the straigth table, add two expression.

Ex.:

QTY:

COUNT(CUSTUMER)

% QTY:

COUNT(CUSTUMER) / COUNT(TOTAL CUSTUMER)

jfkinspari
Contributor III

Re: problem with count

For the second espression you can also just tick the 'relative' box, and use the same formula as from expression 1.

Community Browser