topic Re: Issue with Monthly& Weekly avg in QlikView

Issue with Monthly& Weekly avg

AC — Thu, 05 Apr 2018 15:36:37 GMT

Hello,

I am calculating monthly avg in combo chart, Issue is here when there is no month selection the chart is plotting Sep and Oct only but its not plotting Nov and Dec, If we select Nov and Dec from Month filter then i can see the bars. I am not sure is something wrong with my expression so looking for some help here. Please find the attached sample file.

Re: Issue with Monthly& Weekly avg

sunny_talwar — Thu, 05 Apr 2018 15:59:51 GMT

Try adding the dimensions within the Aggr() function

=if(only(Vehicle_Use) = 'LEASE',

Round(Avg(Aggr(count({<Vehicle_Use-={''},Unit_type-={''},Current_Cust_Number ={'699999','699998'},Rental_Source_Type ={'COMMERCIAL'}, Veh_Cap_Status-={''}>}RENTED_UNITS),Day, MonthName))),

Round(Avg(Aggr(count({<Vehicle_Use-={''},Unit_type-={''},Rental_Source_Type ={'COMMERCIAL'},Veh_Cap_Status-={''}>}RENTED_UNITS),Day, MonthName))))

For week, create a weekstart in the script and add that to aggr function also

Re: Issue with Monthly& Weekly avg

AC — Thu, 05 Apr 2018 18:52:14 GMT

I figured it out Sunny anyway thank you!!