When I started with QlikView, I wanted to replicate what I knew before. One good thing was the possibility to choose the dimensions and measures that compose the table or graph.
It is not complicated to perform such a task in QlikView. This document explains how to do it.
You have also access to XLSX files and the QVW I have used to write the document.
Please enjoy ...