3 Replies Latest reply: Mar 20, 2018 3:39 AM by Jonathan Dienst RSS

    Need Help (Excel Databae)

    bhuvaneshwaran m

      Dear Experts,

      Platform: Qlik Sense

      Database: Excel Feed

       

      I have a excel file for database, in this excel file having 2 sheets. Both the sheets having Year and Month columns. When I select the year or month in the filter pane the result should be sheet1 count and sheet 2 counts separately.

       

      but i m getting while selecting year from filter pane only sheet 1 total only changed.

       

      i want both total should be changed while selecting year from filter pane.

      1. Ex.

      When I select the year or month in the filter pane the result should be sheet1 total and sheet 2 total separately. Like below

       

      Capture.JPG