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: 
Not applicable

Is there a way to calculate the percentage of the items in a dimension?

I want to display the percentage for a particular dimension items listed in it. I had dragged and put it in a vertical position. can some one help me to calculate the % of all the items in a dimension. I had attached the sample file here.

1 Solution

Accepted Solutions
jmvilaplanap
Specialist
Specialist

Hi

Maybe this?

Depending the Dimension you have to change the "TOTAL" expression.

Regards

View solution in original post

3 Replies
sunny_talwar

What is the expected output here? May be take an example and explain?

Not applicable
Author

In my example there is a column name called ErrNames and under in it we have the filter items like,

Bundle ID not reported

Deal ID expired

non-valid Eclipse Deal ID

Product not found in Deal ID

Product not found in the Bundle/ bundle ID reported

Valid Reporting

I want to find the % of all the above items using the Sales Column.

jmvilaplanap
Specialist
Specialist

Hi

Maybe this?

Depending the Dimension you have to change the "TOTAL" expression.

Regards