topic Re: Aggregated funcionts in QlikView

Aggregated funcionts

Joaquin_Lazaro — Fri, 14 Mar 2014 12:30:24 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

Re: Aggregated funcionts

Fri, 14 Mar 2014 12:33:52 GMT

dont know if it works but try

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

Re: Aggregated funcionts

MK_QSL — Fri, 14 Mar 2014 12:36:02 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))

Re: Aggregated funcionts

Joaquin_Lazaro — Fri, 14 Mar 2014 12:37:50 GMT

Not. I want the best ignoring the current selections

Re: Aggregated funcionts

swuehl — Fri, 14 Mar 2014 12:38:13 GMT

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

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

and please try to avoid duplication of threads.

Re: Aggregated funcionts

MK_QSL — Fri, 14 Mar 2014 12:39:13 GMT

Same as swuehl suggested...

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

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

Re: Aggregated funcionts

sunilkumarqv — Fri, 14 Mar 2014 12:46:01 GMT

Try this

=Max(aggr(sum( {1} Total Sales ),YearMonth))

=Min(aggr(sum( {1} Total Sales ),YearMonth))

Re: Aggregated funcionts

Joaquin_Lazaro — Fri, 14 Mar 2014 12:51:38 GMT

The max works good.

The min shows 0 and I don't have cero value on any YearMonth.

I had a problem on the navigator, that's the reason of the duplication therad.

Re: Aggregated funcionts

Joaquin_Lazaro — Mon, 17 Mar 2014 14:48:27 GMT

The answer proposed by swuehl works.

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

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

There was an incorrect value on one record, that generates a wrong value.

Thank you very much.

Joaquín