Avg 3 months sales

Venkatesh_5990 — Wed, 21 Oct 2020 07:02:19 GMT

Hi All,

Need your help for below expression:

Current month closing value/(last 3 months avg sales value)/3*30

this above logic should be like below one, can you please make it as like :

num(((sum(Closing_Value)/1000)/(sum(Sales_Value)/1000))
*
if(GetSelectedCount(Month)=0 or GetSelectedCount(Month)>1,round(num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),
num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),'#,##0'))

Thanks in advance.

Re: Avg 3 months sales

edwin — Thu, 22 Oct 2020 18:51:07 GMT

what is the intent of this expression?

if(GetSelectedCount(Month)=0 or GetSelectedCount(Month)>1,round(num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),
num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),'#,##0'))

what is this field? Date_SecSales_Monthend?

also why do you need help? what is the problem specifically?

topic Re: Avg 3 months sales in QlikView

Avg 3 months sales

Re: Avg 3 months sales