Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

msbhuvanesh003
New Contributor II

Need Help (Excel Databae)

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Need Help (Excel Databae)

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.


3 Replies
hacr-sds
Contributor

Re: Need Help (Excel Databae)

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

MVP
MVP

Re: Need Help (Excel Databae)

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.


MVP
MVP

Re: Need Help (Excel Databae)

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

Re: Need Help

Community Browser