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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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