Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkatesh_5990
Contributor III
Contributor III

Avg 3 months sales

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.

1 Reply
edwin
Master II
Master II

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?