Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

percentage

Hi

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

My Raw Date Look Like

 

CategoryOrder IDResloution Bucket
Apple3845Met
Orange3846Not Met
Mango3847Met
Pineapple3848Not Met
Apple3849Met
Orange3850Not Met
Mango3851Met
Pineapple3852Not Met
Apple3853Met
Orange3854Not Met
Mango3855Met
Pineapple3856Not Met
Apple3857Met
Orange3858Not Met
Mango3859Met
Pineapple3860Not Met
Apple3861Met
Orange3862Not Met
Mango3863Met
Pineapple3864Not Met
Apple3865Met
Orange3866Not Met
Mango3867Met
Pineapple3868Not Met
Apple3869Met
Orange3870Not Met
Mango3871Met
Pineapple3872Not Met
Apple3873Met
Orange3874Not Met
Mango3875Met
Pineapple3876Not Met
Apple3877Met
Orange3878Not Met
Mango3879Met
Pineapple3880Not Met
Apple3881Met
Orange3882Not Met
Mango3883Met

      

I Need in the below format

CategoryMetNot MetTotalMet %Not Met %
Apple823234105778%22%
Orange2941931394%6%
Mango2909338376%24%
Pineapple2347831275%25%

Please help me on this

Thanks in Advance

Regards,

Chethan K

9 Replies
Anil_Babu_Samineni

How you are calculating 823, 294 ...

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anil_Babu_Samineni

This is simple count for them

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Hi Chetan,

Form your given sample data we are getting following result:

CategoryMetNot MetTotalSumMet%Not Met %
Apple10010100%0%
Orange010100%100%
Mango10010100%0%
Pineapple0990%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,

tamilarasu
Champion
Champion

Hi Chetan,

Have a look at the attached file.

Not applicable
Author

Hi

Please find the sample data

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

Regards,

Chethan

tamilarasu
Champion
Champion

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.

Not applicable
Author

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

tamilarasu
Champion
Champion

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

Capture.PNG

rupamjyotidas
Specialist
Specialist

Best to learn Chetan

help.qlik.com