Need Help (Excel Databae)

[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

[hacr]

How does your loadscript look like? And why is the data divided in two sheet, rather than just one?

[jonathandienst · Accepted solution]

Add a derived field to the load to specify the sheet

LOAD

    ...

    'Sheet1' as SourceSheett,

    ...

and

LOAD

    ...

    'Sheet2' as SourceSheett,

    ...

Then you can use SourceSheet to specify the sheet in the KPI expressions.

[jonathandienst]

Please do not cross post questions. It cause clutter and messes up the responses you may get.

Re: Need Help