2 Replies Latest reply: Oct 24, 2016 8:14 AM by krishna m RSS

    getting Grand Total for missing Year

    krishna m

      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