Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
maniram23
Creator II
Creator II

Max sal

Hi friends,

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

5 Replies
PrashantSangle

Hi,

UI level

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
jonathandienst
Partner - Champion III
Partner - Champion III

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
Master III
Master III

Hi,

Sum(Sal)  you should try.

Thanks,
AS

ziadm
Specialist
Specialist

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

MK_QSL
MVP
MVP

In Straight Table

Dimension

Department

Expression

Max(Salary)