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
Usually a percentage would be Sum(FieldName)/Sum(TOTAL FieldName), but obviously this depends on your data. Do you have a sample file?
Complete novice here.
Where should I put that equation?
Under Chart Properties > Expressions.
I get a completely different view
I have never seen that layout before. What version are you using? Try Count(CCRID)/Count(TOTAL CCRID).
Don't know about the version - is it because I'm on XP
Should I type that in the expression box?
Are you working in browser or web view in your Qlikview desktop?
Where do I put that equation?
Can you upload a sample file?
No sorry Cela its on company server
Try typing it here:
Thanks rebeccad that has worked I think - just need to get the scale to show in %.
I should figure that out.
Its qv-9 web layout, you can change turn on/off it.. Any way you can use like
Ah, thanks Mayil. I have never used V.9 before.
How do I get to the same view as rebecca please Mayil?
by using this, you can change the view
Retrieving data ...