Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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?

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

Highlighted
MVP
MVP

Re: Display the highest value of sales only

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

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))

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)) ......

Community Browser