Re: Max sal - Qlik Community

maniram23 · ‎2015-04-22

Hi friends,

I want see the max of sal in dept wise. How i have approach in qlikview?

PrashantSangle · ‎2015-04-22

Hi,

UI level

Straight table -> add dimension ->Department-> Expression->max(Sal)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

jonathandienst · ‎2015-04-22

Assuming you have a data model containing department (dept) and salaries (sal), then create a chart with dept as a dimension and Sum(sal) as the expression.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

amit_saini · ‎2015-04-22

Hi,

Sum(Sal) you should try.

Thanks,
AS

ziadm · ‎2015-04-22

or if you are having you dimension as calculated aggr(Max(Sal),Department)

MK_QSL · ‎2015-04-22

In Straight Table

Dimension

Department

Expression

Max(Salary)