Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Aggregation on large scope than in dimension

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.

 

1 Reply
Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.