Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Which columns are required?
What is the purpose of having Month column in this table? Since this is a budget for the whole year.
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
This might be an option, but you will have to filter out the "subtotal" rows in the spreadsheet.
Mapping table on the spreadsheet.