Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Try typing it here:

Capture.JPG

View solution in original post

22 Replies
Not applicable
Author

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
Author

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable
Author

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable
Author

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable
Author

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable
Author

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable
Author

Sorry Rebeccad

Complete novice here.

Where should I put that equation?

Not applicable
Author

Under Chart Properties > Expressions.

For example:

Capture.JPG

Not applicable
Author

Sorry Rebeccad

Complete novice here.

Where should I put that equation?