topic Re: Max sal in QlikView

Max sal

maniram23 — Wed, 22 Apr 2015 05:23:07 GMT

Hi friends,

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

Re: Max sal

PrashantSangle — Wed, 22 Apr 2015 05:26:14 GMT

Hi,

UI level

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

Regards

Re: Max sal

jonathandienst — Wed, 22 Apr 2015 05:26:49 GMT

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

Re: Max sal

amit_saini — Wed, 22 Apr 2015 05:30:44 GMT

Hi,

Sum(Sal) you should try.

Thanks,
AS

Re: Max sal

ziadm — Wed, 22 Apr 2015 05:36:11 GMT

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

Re: Max sal

MK_QSL — Wed, 22 Apr 2015 06:24:14 GMT

In Straight Table

Dimension

Department

Expression

Max(Salary)