topic Select a highest value in set analysis in QlikView

Select a highest value in set analysis

jolivares — Sat, 02 Apr 2011 17:47:49 GMT

Someone help me...

I want to select a high value in a set analysis even a group of value is selected or not, see the example attached.

Thanks.

Select a highest value in set analysis

francisvandergr — Sat, 02 Apr 2011 20:35:09 GMT

You want the month and day of today ?

Select a highest value in set analysis

jolivares — Sun, 03 Apr 2011 02:12:02 GMT

Yes, as you see in the example it no work as I expected

Select a highest value in set analysis

Anonymous — Mon, 04 Apr 2011 10:05:57 GMT

Hi J.

If your sales are already by day then you don't need SUM.
Isn't just " MAX(Sales) " Enough in this case?

It retruns the highest Sales (which is the day total) for each dimension (=division)

Check the attachment, hope it helps.

Select a highest value in set analysis

Anonymous — Mon, 04 Apr 2011 10:14:27 GMT

Sorry I misread, You want the higest DAY not the Higest Sales.

You are making it to hard on yourself by using YEAR and Month and DAY.
Making just one DATE field, makes it a lot easier.

Check the files and let me know if this helps.