Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
akpofureenughwu
Contributor II

Display the highest value of sales only

Good day sir,

I have a set of data that I am working on. I need to display the highest sales value only

Please how can I achieve that?

Regards

Akpofure

5 Replies

Re: Display the highest value of sales only

Do you have Data set with you, Would you share that data and tell us the Expected result and where you are doing this?

Life is so rich, and we need to respect to the life !!!
akpofureenughwu
Contributor II

Re: Display the highest value of sales only

Hello Babu,

I wold love to know the highest sales for each location as well as the total states..

As well as monthly high, quarter high .. possible weekly (*can it be possible)

Regards

MVP
MVP

Re: Display the highest value of sales only

Did you try max() like:  =Max(Sales)  ?

MVP
MVP

Re: Display the highest value of sales only

Highest Sales with respect to what?

If you want highest sales for country, you can do something like below.

=Max(Aggr(SUM(Sales),Country))

or

=Max(Total Aggr(SUM(Sales),Country))

Highlighted

Re: Display the highest value of sales only

From given data what are you expecting? May be these?

1) Max(Aggr(Sum(sales), location))

2) Max(Aggr(Sum(sales), states)) ......

Life is so rich, and we need to respect to the life !!!
Community Browser