problem in data and calculating avg in the straight table

[#1]

hi

i have a problem with the data and i need to calculate the average value in the table can anyone suggest me how to do

[tresesco]

Avg() ?

[#3]

Are you having any particular issue or do you just need to know how to use the avg() function?

[#4]

in a straight table i have fields as month april may june and its data i need to calculate the (april+may)/2 then

{(april+may)avg}/2 so on how can i

[hic]

If you have the months as different columns, you should most likely use the Crosstable prefix when you load the data:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

Further, you should look at averages here:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages

HIC

[#6]

avg("Field you are averaging here"). If you make selections on your months, this expression will return the average.

For example, if you select months April and May, avg("Field you are averaging here") will return (April + May)/2

[#7]

hi henric

you can have a look at this excel file this is the requirement

[#8]

you can have a look at the excel file and in the excel file the first row that from mar-13 is the sum of my inventories and for that i need to calculate the average in the next row for all the months that are present