topic Re: how do i calculate Percentage in QlikView

how do i calculate Percentage

Sat, 09 Nov 2013 07:20:30 GMT

Dear Sir,

Plz help me to count percentage of my below file. if i select field of response time i.e 3 days ,it show me in % out of total response time by months wise.

Monthwise	Response time	Status
JAN	0	Processing
JAN	0	Processing
JAN	3 Days	Justified
JAN	7 Days	Justified
JAN	3 Days	Justified
JAN	3 Days	Unjustified
JAN	25 Days	Unjustified
JAN	25 +Days	Justified
JAN	3 Days	Justified
JAN	3 Days	Justified
JAN	3 Days	Unjustified
JAN	0	Processing
FEB	15 Days	Justified
FEB	3 Days	Unjustified
FEB	3 Days	Unjustified
FEB	15 Days	Unjustified
FEB	3 Days	Unjustified
FEB	3 Days	Justified
FEB	3 Days	Justifie

Re: how do i calculate Percentage

Gysbert_Wassenaar — Sat, 09 Nov 2013 09:19:04 GMT

Use monthwise as dimension and this expression: count({<[Response time]={'3 Days'}>}Status)/count( total <Monthwise> Status)

See attached qvw.

Re: how do i calculate Percentage

Mon, 11 Nov 2013 09:04:33 GMT

Hi Gysbert,

Thanks for your quick response.

I have done the job explain by you, but I am not getting result which I need.

Re: how do i calculate Percentage

Gysbert_Wassenaar — Mon, 11 Nov 2013 09:09:31 GMT

I misunderstood your question. Try count(Status)/count({<[Response time]=>} total <Monthwise> Status)

Re: how do i calculate Percentage

Mon, 11 Nov 2013 09:14:01 GMT

Ok,I will check and let u know.

Re: how do i calculate Percentage

Mon, 11 Nov 2013 09:21:03 GMT

yes, it is working,

however if I wish to not count '' processing'' in total , then what is formula.

Re: how do i calculate Percentage

Gysbert_Wassenaar — Mon, 11 Nov 2013 09:34:24 GMT

In this case this will do:

count(Status)/count({<[Response time]=-{0}>} total <Monthwise> Status)

This will work to specifically exclude status Processing, even if response time were not 0:

count({<Status-={'Processing'}>}Status)/count({<[Response time]=,Status-={'Processing'}>} total <Monthwise> Status)

Re: how do i calculate Percentage

Mon, 11 Nov 2013 10:26:09 GMT

thank you , I will check and update to you.

I have query about sheet .

how do I prevent field and object values is not change while change of sheet. or in other way no change of field and object in case of change a sheet.