Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vishalgoud
Contributor III

avg issue, how we calculate in general..??

Hi , need urgent help in calculating the avg for fully consumed passes.

my report willl show information about usage of the tariff plans like how they consumed, fully consumed, partially consumed, unused etc..

for all the above am calcuating at script level only excpet for avg, for avg the formula we have to use is :

for avg number of passes which are fully consumed - we have to use the below formula given by the business, when i write the same in the script and excute it is not giving the correct avg.. in general how we calculate the average for these cases.

= (NUM_OF_FULLY_CONSUMED * NUM_DAYS) / SUM(NUM_DAYS) WHERE NUM_OF_FULLY_CONSUMED != 0

Now am in great trouble that where to use this . .. please help me whether i have to calculate the avg at script level or in the UI, and what is the way to do it, thanks in advance.