Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
How you are calculating 823, 294 ...
This is simple count for them
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,
Hi Chetan,
Have a look at the attached file.
Hi
Please find the sample data
https://www.dropbox.com/s/af7v7p3dnv9m0yo/Smaple%20File.xlsx?dl=0
Regards,
Chethan
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.
How to Hide the total or How to Sum the (MET) & (NOT MET)
You can remove the total by enabling the "No Totals" option in expression tab. Have a look at the attached file for better understanding.
Best to learn Chetan
help.qlik.com