Solved: Re: How do I express data as a % of Count in a Lin... - Page 2 - Qlik Community

Report Inappropriate Content · ‎2012-12-07

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

Report Inappropriate Content · ‎2012-12-07

Sorry rebeccad.

Complete novice here.

Where do I put that equation?

Regards

Les Miles.

Report Inappropriate Content · ‎2012-12-07

I get a completely different view

CELAMBARASAN · ‎2012-12-07

Can you upload a sample file?

Report Inappropriate Content · ‎2012-12-07

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

CELAMBARASAN · ‎2012-12-07

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

Report Inappropriate Content · ‎2012-12-07

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

Should I type that in the expression box?

Regards

Les Miles.

Report Inappropriate Content · ‎2012-12-07

No sorry Cela its on company server

Report Inappropriate Content · ‎2012-12-07

Try typing it here:

MayilVahanan · ‎2012-12-07

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)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-12-07

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

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