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

    getting Grand Total for missing Year



      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



      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