Re: Cross Table - How to achieve this file - Qlik Community

renuka_sasikumar · ‎2019-10-11

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 · ‎2019-10-13

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 · ‎2019-10-16

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

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Victor_Alumanah · ‎2019-10-16

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

Mapping table on the spreadsheet.

While we teach we learn