Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculate Top 40%

Hi All,

I want to calculate the Count for Top 40 % by tons using set analysis for Material Type (ABC) .I have attached excel file.

Capture.PNG

Thanks in advance.

2 Replies
omkarvamsi
Creator
Creator

Hi Satya,

Please elaborate your issue.

On which basis percentage is calculated.

i couldn't able to understand "Count for Top 40 % by tons "

you need which count?

Anil_Babu_Samineni

Do you mean < 40%

Sum({<Value(Count of Tons) = {'<= 40.00 %'}>} Tons)

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