Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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 - Champion
Partner - Champion

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
Partner - Creator
Partner - Creator

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)