How to create this specific table

[salezian]

Hi Everyone,

How to create this specific format of table in qlik. It should contain data for full year  and then YTD. In Excel it's easy to do, but in Qlik I can't handle it.

Thanks in advance.

[sunny_talwar]

Are you looking to create this on the front end or backend? Can you possiblly share some data (in Excel file)?

[Anonymous]

Hi,

I thought in two solutions

1- You can create a dimension month-year and each row will be an expression

2- You can do a set analysis for each column with a period, e.g  sum(<month={}, year={}>) and in the name of the column you edit as the month-year

Best Regards