Qlikview Crosstable Insanity

[#1]

Hi ,

Im going mad here not sure what else to try!. The pictures should explain all. I have data in the following format (pic1) and the crosstable seems to work perfect for what i need. The preview of the result of the crosstable works perfect to how i want the end result to look (pic2) however when I click finish and reload it goes back to the original format! (pic3). What am I doing wrong?

Thank you for your time

Sam

[#2 · Accepted solution]

Fixed it, had to add a fake qualifier field. Presumably a bug.