Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
When I select the year or month in the filter pane the result should be sheet1 total and sheet 2 total separately. Like below
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.
How does your loadscript look like? And why is the data divided in two sheet, rather than just one?
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.
Please do not cross post questions. It cause clutter and messes up the responses you may get.