Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dries_clairhout
Creator
Creator

Static reference line

Dear community,

For a client of mine we hav this reference line:

=avg(total aggr(sum($(vColli))/$(vDag),Datum, magazijnier))

Now if I Select something, the line adjusts.

But actually it should keep the total average line even when selecting a single person.

Here's a visual of the graph:

Screenshot_2.jpg

Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

Or this

=Avg(TOTAL {1} Aggr(Sum({1} $(vColli))/$(vDag), Datum, magazijnier))

View solution in original post

8 Replies
agigliotti
Partner - Master III
Partner - Master III

maybe this:

=avg( {1} total aggr(sum($(vColli))/$(vDag),Datum, magazijnier))


I hope it helps.

sunny_talwar

Or this

=Avg(TOTAL {1} Aggr(Sum({1} $(vColli))/$(vDag), Datum, magazijnier))

amit_gupta
Contributor III
Contributor III

=avg(  total {1} aggr(sum({1}$(vColli))/$(vDag),Datum, magazijnier))


I think in Variable's expresssion  also, you need to modify:


$(vColli)

$(vDag)



dries_clairhout
Creator
Creator
Author

Gives back a completely different result :s

dries_clairhout
Creator
Creator
Author

Sorry for asking,

modify how exactly?

thanks

ckarras22
Contributor III
Contributor III

Amit is correct, what exactly vColli and vDag have as values?

sunny_talwar

Would you be able to share a sample or an image to show what your issue is?

dries_clairhout
Creator
Creator
Author

Vcolli is a numeric value, if you have a crate with 10 articles in it, 1 article = 1colli

Vdag is a date (dag = day)