topic Re: Calculating average on time drill down in QlikView

Calculating average on time drill down

Wed, 11 Sep 2013 03:48:05 GMT

Hi Experts,

I have created drill down menu for Time(Year-Month-Day-Minute).I have values available for days of month.

ex. for month-5

day value

1 a

2 b

3 c

.. ..

31 d

For Month value, I want to calculate average of day values.

for month 5, monthVal= avg(a+b+c+...d)

So when i drill up from day to month, it will show me average value of all days i.e monthVal of that particular month.

Please help

Thank You

Wed, 11 Sep 2013 05:06:45 GMT

Hi,

Try like this

In expression

IF(GetCurrentField(DrillDownGroupName)='Month',Avg(Value),'Default Calculation')

Hope it helps you

Wed, 11 Sep 2013 05:08:39 GMT

Hi,

This is not give a proper solution then please post your sample file

Wed, 11 Sep 2013 10:28:32 GMT

hey Thanks, Its working

v_iyyappan — Wed, 11 Sep 2013 10:35:29 GMT

Hi,

If u got correct solution means please closed the thread and give mark. because its motivate for us.

Wed, 11 Sep 2013 10:36:05 GMT

If its working then mark it as correct answer