Greatest by grouping i.e sql=> sum ... group by

Thu, 26 Mar 2015 21:43:46 GMT

Hello Everyone,

I have a chart as the one that's pictured. It's a Sales vs Month chart. What I would like to do is find ask the following question using Set Analysis: "Given the current selection, find the greatest "sales by month" value."

I know what I would do in SQL, which is I would SUM over Sales, and then GROUP BY Month, Blah, and Blah. But I'm know that won't cut it here.

Any help is greatly appreciated.

Re: Greatest by grouping i.e sql=> sum ... group by

Gysbert_Wassenaar — Fri, 27 Mar 2015 09:42:17 GMT

max(aggr(sum(Sales),Month))

topic Greatest by grouping i.e sql=> sum ... group by in QlikView

Greatest by grouping i.e sql=> sum ... group by

Re: Greatest by grouping i.e sql=> sum ... group by