Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Inputfield in a Pivot Table


Hi,

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

Any other suggestions?

Thanks,

Santhya

0 Replies