I am new to Qlikview and currently getting hold of the usage of the tool. I have a requirement where in I need to create a Pivot table with Dimension and Facts. The Drawback is for certain dimensions there is no data in the fact table, Consider the example as attached. I have a accounts table with header and sub header but these records will not have corresponding data in Fact table. But i need header and sub header to be part of Pivot table. I cannot generate the facts inline or insert them as i have thousands of sub header under a header and nearly 20-30 million rows needs to generated. Please suggest a way to avoid data generation and handling the same in Qlik. I have also attached the Test data, QVW and Desired output format.
