Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Contributor III

Table With Max Value for Dimension Name

Hi All,

I have the below tables

RegionRevenue
North100
South200
East300
West400

Department IDRevenue

1

200
2300
3400
475
525

I'd like to create a table that has just the name of the Dimension and the max % of Revenue for that dimension and the Dimension value that is the max such as below

DimensionMax Revenue ShareDimension Value
Region40%West
Department ID40%3

Does anyone have any ideas?

Thanks,
Mark

Tags (2)