I have a SQL query that creates a table, and every month 2 new columns will be added for that table related to the current month.
I have tried without success to set up a flat table (visual) in Qlik that will automatically expand every month to include these table. Is there a way to do this, and i so please point me in the right direction.
Your sql creates a crosstable which is for many scenarios quite unsuitable. You may consider to change it there or at least within Qlik. The why + how to could you see here: The Crosstable Load - Qlik Community - 1468083.
It contains details regarding a selection of insurance policies with details, and the for every month two columns are added, one for Claims and one for premiums. The table displays all details, not only summaries.
The granularity of the table and/or the amount of records isn't relevant else only the structure of the data matters. Regarding to your description it speaks nothing against a transforming else it should provide a lot of benefits.
