Need Help

[msbhuvanesh003]

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

[msbhuvanesh003]

Exactly correct .... Here after i will do Ma'am...