Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kdstrin1
Contributor II
Contributor II

How to Calculate Percentage off Custom Filtered Dataset

Hi-

I'm building a dashboard off of a large dataset and would like the bar charts to display a percentage of the total filtered dataset. The users will be able to adjust the filters so how do I build a function to calculate a subtotal off of the selected dataset?

Using made up numbers, I entered what I would like to show; the market share attributed to each entity by year. So 2020 in red is capturing 20% of the filtered dataset for 2020, competitor A is capturing 5% of the filtered dataset for 2020, etc.

Any assistance you can offer on how I can accomplish this greatly appreciated.

Thank you

Labels (4)
2 Replies
Venkadesh_Ponnu
Partner - Contributor III
Partner - Contributor III

Do you want to show contribution in BarCharts only? Otherwise, Tree map is also very helpful in such scenario.

kdstrin1
Contributor II
Contributor II
Author

Yes, i would like to show it in a bar chart as i'm recreating a view currently used through manual data manipulation in excel