Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Cross Table - How to achieve this file

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.

 

Labels (1)
3 Replies
Highlighted
Partner
Partner

Re: Cross Table - How to achieve this file

Which columns are required?

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

 

Highlighted
Digital Support
Digital Support

Re: Cross Table - How to achieve this file

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.
Highlighted
Creator
Creator

Re: Cross Table - How to achieve this file

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

Mapping table on the spreadsheet.

clipboard_image_0.png

While we teach we learn