Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkatesh_5990
Contributor
Contributor

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
Specialist III
Specialist III

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?