getting Grand Total for missing Year

[#1]

Hi

Thanx for ur help in Advance

1 excel file with 3 columns as Year, Movie, Production Budget

2 in QlikView, Movie used as Dimension and Sum([Production Budget]) in Expression of Pivot Table

3 Year field used in Slider object

Pivot Data changes ie., Movie and Production Budget, when there is a changes in Year of Slider object

ISSUE

there is no movies data in Year of 1932,1921 and other years,  when i moved to that year in Slider, Pivot table shows Total of Production Budget ie., from 1900 to 2016 Production Budget Total

Please give the solution to NOT get Grand Total for those Year does not have movie data

[Gysbert_Wassenaar]

Can you post a small qlikview document that demonstrates the problem?

[#3]

Hi Gysbert Wassenaar,

explained issue in attached Word document with screenshot and attached excel file also which using for practicing

thanks

Krishna