topic Re: Dimensions with No Facts Pivot Table in QlikView

Dimensions with No Facts Pivot Table

Tue, 29 Sep 2015 14:51:23 GMT

Hi All,

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.

Re: Dimensions with No Facts Pivot Table

settu_periasamy — Wed, 30 Sep 2015 05:13:03 GMT

Hi,

May be you can try this with Straight Table (If it suits).

Check the below attachment.

Re: Dimensions with No Facts Pivot Table

Wed, 30 Sep 2015 14:04:29 GMT

Hi,

This does not work, i have hundreds of Currencies. Also i may include year and month in pivot as well.

i cannot go hardcoding values or valuelist in straight table.

Thanks