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: 
Anonymous
Not applicable

Chart by month from two different tables

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.

1 Reply
robert_mika
Master III
Master III

Could you attached your raw data not the Qlikview extract?