topic sum(aggr(max)) with set analysis in QlikView

sum(aggr(max)) with set analysis

geogou1973 — Mon, 22 May 2017 10:05:09 GMT

Hello.

I have the following expression

sum(aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and in dimension the field COMPANY_NAME_HOURLY_CURRENT

How can i write this expression if i don't use dimension and i want to have results only for the COMPANY_NAME_HOURLY_CURRENT='01' in a chart.

Thank you in advance.

Re: sum(aggr(max)) with set analysis

MK_QSL — Mon, 22 May 2017 10:12:02 GMT

May be

sum({<COMPANY_NAME_HOURLY_CURRENT = {'01'}>}aggr(max({<COMPANY_NAME_HOURLY_CURRENT = {'01'}>}RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

Re: sum(aggr(max)) with set analysis

geogou1973 — Mon, 22 May 2017 10:15:33 GMT

Unfortunately the result is 0,00

Re: sum(aggr(max)) with set analysis

MK_QSL — Mon, 22 May 2017 10:18:48 GMT

Provide sample data or sample app.

Re: sum(aggr(max)) with set analysis

geogou1973 — Mon, 22 May 2017 14:19:31 GMT

I want to SUM the MAX(RETAIL_HOURLY_CURRENT) by DATE_ID_HOURLY_CURRENT,

COMPANY_NAME_HOURLY_CURRENT,

ZAP_CODE_HOURLY_CURRENT

for the COMPANY_NAME_HOURLY_CURRENT='01'

and i want to do this without a field dimension only in expression just a number