Average in Qlikview

[vijayit43]

QlikView Dashboard when select No of days(EX-1,2,3,4) Then Show Average Of (4) Selected Days in expression Field

[MK_QSL]

can you elaborate little bit more?

You can have average as below

Avg(Sales)

[vijayit43]

QV filter field is day (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31) and Expression Field is sales show day wise if user select date 1,2,3,4,5 then show avg sales Ex(Sales/5)

[its_anandrjs]

Write like

Ex:-  Sales / GetSelectedCount(day)

For Example:-

=  ( Sum(YourSalesFieldHere) / GetSelectedCount(YourDayFieldHere) )

[MK_QSL]

You can simply write below in text box...

=AVG(Sales)

[vijayit43]

thanks,, its work for me....

[its_anandrjs]

If you got solution from the thread so mark the thread as Correct / helpful.

Regards