topic Cross Table - How to achieve this file in QlikView

Cross Table - How to achieve this file

renuka_sasikumar — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have attached file, not able to understand how load this QlikView, can anyone help on it.

Tried using Cross Table but no success.

Arthur_Fong — Mon, 14 Oct 2019 00:51:55 GMT

Which columns are required?

What is the purpose of having Month column in this table? Since this is a budget for the whole year.

Brett_Bleess — Wed, 16 Oct 2019 15:55:41 GMT

Here is a Design Blog post on Cross Table load that may help:

Regards,
Brett

Victor_Alumanah — Wed, 16 Oct 2019 16:47:59 GMT

This might be an option, but you will have to filter out the "subtotal" rows in the spreadsheet.

Mapping table on the spreadsheet.