topic Re: percentage in QlikView

percentage

Wed, 25 Nov 2020 16:16:04 GMT

Am new to qlikview please help me to how to find the details.

My Raw Date Look Like

Category	Order ID	Resloution Bucket
Apple	3845	Met
Orange	3846	Not Met
Mango	3847	Met
Pineapple	3848	Not Met
Apple	3849	Met
Orange	3850	Not Met
Mango	3851	Met
Pineapple	3852	Not Met
Apple	3853	Met
Orange	3854	Not Met
Mango	3855	Met
Pineapple	3856	Not Met
Apple	3857	Met
Orange	3858	Not Met
Mango	3859	Met
Pineapple	3860	Not Met
Apple	3861	Met
Orange	3862	Not Met
Mango	3863	Met
Pineapple	3864	Not Met
Apple	3865	Met
Orange	3866	Not Met
Mango	3867	Met
Pineapple	3868	Not Met
Apple	3869	Met
Orange	3870	Not Met
Mango	3871	Met
Pineapple	3872	Not Met
Apple	3873	Met
Orange	3874	Not Met
Mango	3875	Met
Pineapple	3876	Not Met
Apple	3877	Met
Orange	3878	Not Met
Mango	3879	Met
Pineapple	3880	Not Met
Apple	3881	Met
Orange	3882	Not Met
Mango	3883	Met

I Need in the below format

Category	Met	Not Met	Total	Met %	Not Met %
Apple	823	234	1057	78%	22%
Orange	294	19	313	94%	6%
Mango	290	93	383	76%	24%
Pineapple	234	78	312	75%	25%

Please help me on this

Thanks in Advance

Regards,

Chethan K

Re: percentage

Anil_Babu_Samineni — Wed, 30 Nov 2016 06:52:37 GMT

How you are calculating 823, 294 ...

Re: percentage

Anil_Babu_Samineni — Wed, 30 Nov 2016 06:55:41 GMT

This is simple count for them

Re: percentage

Anonymous — Wed, 30 Nov 2016 07:17:52 GMT

Hi Chetan,

Form your given sample data we are getting following result:

Category	Met	Not Met	TotalSum	Met%	Not Met %
Apple	10	0	10	100%	0%
Orange	0	10	10	0%	100%
Mango	10	0	10	100%	0%
Pineapple	0	9	9	0%	100%

Here I have assumed that you are calculating met and Not Met % against total(Met+Not Met)

Please find attached QVW for detailed information.

Thanks,

Re: percentage

tamilarasu — Wed, 30 Nov 2016 07:33:39 GMT

Hi Chetan,

Have a look at the attached file.

Re: percentage

Wed, 30 Nov 2016 09:24:10 GMT

Please find the sample data

https://www.dropbox.com/s/af7v7p3dnv9m0yo/Smaple%20File.xlsx?dl=0

Regards,

Chethan

Re: percentage

tamilarasu — Wed, 30 Nov 2016 09:34:07 GMT

Have you tried to open any of the above attached qvw files? Try to open the attachment and modify the path as per your need. I checked Pooja's solution and mine with your sample data and it's dispaying the result as expected.

Re: percentage

Wed, 30 Nov 2016 10:04:03 GMT

How to Hide the total or How to Sum the (MET) & (NOT MET)

Re: percentage

tamilarasu — Wed, 30 Nov 2016 10:15:00 GMT

You can remove the total by enabling the "No Totals" option in expression tab. Have a look at the attached file for better understanding.

Re: percentage

rupamjyotidas — Wed, 30 Nov 2016 14:46:08 GMT

Best to learn Chetan

help.qlik.com