Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avg line!

7Capture.PNG

Hi!

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!!!

David

3 Replies
sunny_talwar

May be like this:

Sum(TOTAL Count)/Sum(TOTAL Hours)

Anil_Babu_Samineni

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)
stabben23
Master
Master

Hi,

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

referensline.GIF