Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avg line!



This is a productivity calculation for each date!

I simply divided 'count' for each day by 'hour' for each day.

I want to have a reference line that will have overall productivity.

if I just use a trend line avg selection, it just gives back the avg of data points for each date.

but that's not what I want.

I want entire counts for all days divided by entire hours for all days and have a line that goes across the table horizontally.

if I could put in a line that is free from effect of dimension, it will solve the issue.

but i guess there could also be other ways.

Please help!

thank you in advance!!!


3 Replies

May be like this:

Sum(TOTAL Count)/Sum(TOTAL Hours)


I simply divided 'count' for each day by 'hour' for each day.

For Single Day What you've tried. i mean which expression you've written.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)


you can use referenceline here to have a line a cross the chart.