topic Re: Aggregated funcionts in QlikView

Aggregated funcionts

Joaquin_Lazaro — Fri, 14 Mar 2014 12:31:14 GMT

Hello:

I've two text boxes with these expressions

= max(aggr(sum(Sales), YearMonth))

= min(aggr(sum(Sales), YearMonth))

The best and the worse sales grouped by YearMonth, over the current selections.

Now I need to create to new text boxes with the best and the worse sales grouped by YearMonth, but over the complete data model.

What's the correct expression to get what I need?

Thanks for your help.

Joaquín

MK_QSL — Fri, 14 Mar 2014 12:33:32 GMT

= max(aggr(sum({1}Sales), YearMonth))

= min(aggr(sum({1}Sales), YearMonth))

= max(aggr(sum(TOTAL Sales), YearMonth))

= min(aggr(sum(TOTAL Sales), YearMonth))

swuehl — Fri, 14 Mar 2014 12:37:20 GMT

= max({1} aggr(sum({1} Sales), YearMonth))

= min({1} aggr(sum({1} Sales), YearMonth))