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.

Not applicable

How do I express data as a % of Count in a Line Graph

Hi

I'm trying to express information over time as a %age of the total instances in a period.

So if there are 30 out of 100 this should be 30% but if 120 instance 30 should be 25%

Any guidance please

1 Solution

Accepted Solutions
Not applicable

Re: How do I express data as a % of Count in a Line Graph

Try typing it here:

Capture.JPG

22 Replies
Not applicable

Re: How do I express data as a % of Count in a Line Graph

Usually a percentage would be Sum(FieldName)/Sum(TOTAL FieldName), but obviously this depends on your data.  Do you have a sample file?

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Under Chart Properties > Expressions.

For example:

Capture.JPG

Not applicable

Re: How do I express data as a % of Count in a Line Graph

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Community Browser