both screenshots look like Sense Pivot tables, with different sets of Columns and Rows. While keeping in mind that some of the unlimited Excel flexibility can't be matched, your specific needs (IMHO) can be solved in a Pivot table.
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!
It seems best to convert your data to a regular table first by using the "Crosstable" load script. Below is an article to discuss the topic. Then you can have more visibility to the data. I hope this helps.