What's the logic behind the data and the formatting? Unless there's an algorithm to calculate it, Qlikview can't determine what should be shown and how it should be formatted. In that case you'll have to use something like excel to create the required result manually.
