Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Contributor II

Re: Average in diagramme

Try

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

Not applicable

Re: Average in diagramme

Unfortunately, it doesn't work

santhoo_san
Contributor II

Re: Average in diagramme

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

Not applicable

Re: Average in diagramme

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
Contributor II

Re: Average in diagramme

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

Not applicable

Re: Average in diagramme

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

Community Browser