Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Previous Month at the Bottom of Straight Table

Hi,

I have a requirement like the following:-

<30 Days31-60 Days
61-90 Days
>90 Days
Country A



Country B



Country C



Country D



Country E



Previous Month



Previous Year



I manage to create the table using a straight table, but without the Previous Month and Previous Year. How can I add these two rows into the same table? Currently I'm creating another tables for these two rows, but the user cannot export it into a single excel.

1 Reply
AbhijitBansode
Specialist
Specialist

To get this done, you have to modify your data model to add strings 'Previous Month' and 'Previous Year' to dimension. For getting metrics of above dimension values, need to concatenate their aggregated values to oringinal metrics table. And this procedure can become complex depending upon your existing data model structure.

But, as you have stated above, 'you are currently creating another table for two rows'. I would suggest you to go with the same and in order to export both tables/charts to same excle sheet, there is workaround available.

For this, you can refer below excellent post by Stefan WALTHER:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/