Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
m_perreault
Creator III
Creator 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

0 Replies