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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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