Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

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
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
akpofureenughwu
Creator III
Creator III
Author

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

tresesco
MVP
MVP

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

MK_QSL
MVP
MVP

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

Anil_Babu_Samineni

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

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)