Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sharmasapna
Contributor III
Contributor III

Qlikview Aggr Function max

Hi Team

Need Help in getting a result.

PFA image.

I have a requirement where I need to display net price. I have written below expression s:

= Max(Aggr(Sum(If( [Net Sales] > 0 AND [Net Volume] > 0, [Net Sales] /[Net Volume] )), Region, Destination))

for considering +values .

= Max(Aggr(Sum(If( [Net Sales] < 0 AND [Net Volume] < 0, [Net Sales] /[Net Volume] )), Region, Destination))

for considering - values.

I want only one expression for both the cases.

Please suggest

Thanks In Advance

11 Replies
albi_prakash
Creator II
Creator II

Hi,

PFA. Is that you looking for?

-Jai

jonathandienst
Partner
Partner

The answer Sunny gave you on the previous thread you posted on this topic will precisely what you need,

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