Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
EGDR
Contributor II
Contributor II

Rolling 12 months average based on two month end Dates from two tables

Hi Friends,

I have two month end date fields in two tables, A_Date  from Table A table and B_Date from Table B table and have two measure fields C and D, where dates was matched in both tables and calculate sum and need to find Average 

C_M/D,

A_Date having 14 month end dates and B_Date having 12month end dates

first need to calculate sum and need to find total average 

I have tried like below

If(A_Date=B_Date, Sum(C_M)/Sum(D),0)

tried one more logic

If(Num(A_Date)=Num(B_Date), Sum(C_M)/Sum(D),0)

I am getting numerator values is correct , the only denominator values getting wrong(D values )   

Please help me on this issue, not getting output 

2 Replies
vinieme12
Champion III
Champion III

please post some sample data and expected output

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
EGDR
Contributor II
Contributor II
Author

New.png

Please refer this screenshot for your reference