Discussion Board for collaboration on QlikView Scripting.
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?
Do you have Data set with you, Would you share that data and tell us the Expected result and where you are doing this?
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)
Did you try max() like: =Max(Sales) ?
Highest Sales with respect to what?
If you want highest sales for country, you can do something like below.
From given data what are you expecting? May be these?
1) Max(Aggr(Sum(sales), location))
2) Max(Aggr(Sum(sales), states)) ......