22 Replies Latest reply: Dec 10, 2012 8:50 AM by Mayil Vahanan Ramasamy

# 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%

• ###### 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?

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

Complete novice here.

Where should I put that equation?

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

Complete novice here.

Where should I put that equation?

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

Under Chart Properties > Expressions.

For example:

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

I get a completely different view

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

I have never seen that layout before.  What version are you using?  Try Count(CCRID)/Count(TOTAL CCRID).

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

Don't know about the version - is it because I'm on XP

Should I type that in the expression box?

Regards

Les Miles.

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

Are you working in browser or web view in your Qlikview desktop?

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

Complete novice here.

Where should I put that equation?

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

Complete novice here.

Where should I put that equation?

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

Complete novice here.

Where should I put that equation?

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

Complete novice here.

Where should I put that equation?

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

Complete novice here.

Where should I put that equation?

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

Complete novice here.

Where do I put that equation?

Regards

Les Miles.

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

Can you upload a sample file?

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

No sorry Cela its on company server

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

Try typing it here:

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

Thanks rebeccad that has worked I think - just need to get the scale to show in %.

I should figure that out.

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

Hi

FYI

Its qv-9 web layout, you can change turn on/off it.. Any way you can use like

Count(CCRID)/Count(total CCRID)

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

Ah, thanks Mayil.  I have never used V.9 before.

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

How do I get to the same view as rebecca please Mayil?

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

hi

by using this, you can change the view