Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables in the qvw. One contains the start date and end date of the customers and using a formula I can find out how many were active on say 15th of the month.
In a separate table I have claims paid and I can create a summary by using Monthname(Treatment_Date).
However, I want the two outputs in the same table as I want to take averages.
In the excel I have attached the output from the two tables and on third sheet have shown the output which I want.
Would appreciate if someone can help me out here.
Thanks.
Could you attached your raw data not the Qlikview extract?