Aggregation on large scope than in dimension

antonbb — Mon, 22 Jun 2020 19:19:54 GMT

Hello,

I can't figure out QV behaviour, so could smbd help me understand

I have hourly data for power consumption. One hour in day is marked as peak hour.

In pivot table i've dimension:

Day

Expressions:

only({<PeakHourMark={1}>}POWER.VAL) - power consumption for peak hour,

=MAX(aggr(max(POWER.VAL),%Date)) - maximum per day

=SUM(aggr(SUM(POWER.VAL),%Date)) - Total per day

=SUM(aggr(SUM(POWER.VAL),[Year Month])) - Monthly consumption

and i've a problem with monthly expression, QV show data for monthly only on first day of month and i don't understand why

I've attach excel file with example.

Re: Aggregation on large scope than in dimension

Brett_Bleess — Wed, 08 Jul 2020 20:10:34 GMT

You very likely need to attach the QVW file on this one, as going to be hard to troubleshoot without being able to see the data model and expressions in the chart etc.

Regards,
Brett

topic Re: Aggregation on large scope than in dimension in QlikView

Aggregation on large scope than in dimension

Re: Aggregation on large scope than in dimension