topic Inputfield in a Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Inputfield-in-a-Pivot-Table/m-p/716106#M257512 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have to use an inputfield field column in a Pivot Table. Assume this Pivot Table is sparsely populated meaning we do not have measures for all combinations of dimensions in the underlying fact table. When I try to input a value in the gaps in the Pivot table, the table crashes and becomes unuable until I remove the value I had typed in. I suppose qlikview could not assign the input value to any combination of dimension in the fact table. The immediate solution that I come up with is to create a cross join between the dimensions and store into the fact. But this definitely would increase my table size and will hit the performance</P><P></P><P>Any other suggestions?</P><P></P><P>Thanks,</P><P>Santhya</P></BODY></HTML> Fri, 20 Jun 2014 08:01:51 GMT santhyamuthu 2014-06-20T08:01:51Z Inputfield in a Pivot Table https://community.qlik.com/t5/QlikView/Inputfield-in-a-Pivot-Table/m-p/716106#M257512 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have to use an inputfield field column in a Pivot Table. Assume this Pivot Table is sparsely populated meaning we do not have measures for all combinations of dimensions in the underlying fact table. When I try to input a value in the gaps in the Pivot table, the table crashes and becomes unuable until I remove the value I had typed in. I suppose qlikview could not assign the input value to any combination of dimension in the fact table. The immediate solution that I come up with is to create a cross join between the dimensions and store into the fact. But this definitely would increase my table size and will hit the performance</P><P></P><P>Any other suggestions?</P><P></P><P>Thanks,</P><P>Santhya</P></BODY></HTML> Fri, 20 Jun 2014 08:01:51 GMT https://community.qlik.com/t5/QlikView/Inputfield-in-a-Pivot-Table/m-p/716106#M257512 santhyamuthu 2014-06-20T08:01:51Z