Discussion Board for collaboration related to QlikView App Development.
I have daily balances in my table as following
now the thing is i wana calculate avg weekly monthly and quarterly balance the formula i am using is sum(AGGr(avg(Balance),Week) and when i use the same for the month it shows the same value as in sum(AGGR(AVG(Balance),CalenderMonth) so please guys let me know where i am going wrong.
Something like this:
,WeekName(Date) as MyWeekName
,QuarterName(Date) as MyQuarterName
,MonthName(Date) as MyMonthName
LOAD Date(Date) as Date,
(biff, embedded labels, table is Sheet1$);
Then you cna use the following:
This only works if i don't select a date but when i select a date it shows the same value for all the keys i.e if there is 1,2,3 it will show the same value for 1,2,3.
1,2,3 can be values in the column name KEY.