topic getting Grand Total for missing Year in QlikView

getting Grand Total for missing Year

Sun, 23 Oct 2016 02:47:49 GMT

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

Re: getting Grand Total for missing Year

Gysbert_Wassenaar — Mon, 24 Oct 2016 08:43:09 GMT

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

Re: getting Grand Total for missing Year

Mon, 24 Oct 2016 12:14:59 GMT

Hi Gysbert Wassenaar,

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

thanks

Krishna