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

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

avg issue, not matching with Sql result

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

my report willl show information about usage of the data plans. like 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 :

= (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 and which form i have 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.

0 Replies