Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average in diagramme

Hi everyone!

What function allows add average over two variables.

I used:

Avg (VAR1 and VAR2).

It doesn't work properly.

Many thanks in advance!

6 Replies
santhoo_san
Partner - Creator II
Partner - Creator II

Try

=rangeAvg($(VAR1),$(VAR2))

Not applicable
Author

Unfortunately, it doesn't work

santhoo_san
Partner - Creator II
Partner - Creator II

Capture3.JPGFor me on my sample working, it works. Share a sample app. let us try.

Not applicable
Author

Santhosh,

Sorry for the question. Can I use this function in expressions (after upoading data)?  When I use it in expression aberage over two fields is not estimated at all.

santhoo_san
Partner - Creator II
Partner - Creator II

yes, you can use it. check if your variables are getting some values before averaging it.

Not applicable
Author

Yes, they get. I did it the same way as in your example. Average for separate fields are calculated, but average for two fields is not