How to reach simple soliton Cross Table Records - Is it possible

[#1]

I have cross table but I can't make a simple solition for my aim. I am making 3-4 table for my records.It doesnt seems logical. I guess Qlik can solve with cross table properties but i can't success. I attached a excel file clearly discrebed what i want to make.

I hope it is possible. I am looking forward your help as a qvw solition

Thanks

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3718.qlikillustration.xlsx:550:0]

[#2]

Hi,

Qlikview works fine with star schemas. To handle the nullvalues in a proper manner, I build a little star during loading. Take a look at the script. I am sure, you will find some ideas and challenges.

Regards, Roland