Two different filters in two sheets in the same app

[l26b]

Hello,

I have two different data sets - one with current data and one with historical data but same column names. 

Table 1 Current Data 

ColumnName1 

ColumnName2

ColumnName3

Table2 Historical Data

ColumnName1 

ColumnName2

ColumnName3

I want to load both tables into UI app but in Sheet 1 I want to display data for current data and Sheet 2 I want to display historical data.

I want ColumnName1, ColumnName2 and ColumnName3 filters to be applied on both sheets(so I do not want to rename columns) but in Sheet one I would need a filter or logic applied to show only Current Data and on Sheet 2 to display historical data. 

How can I do this or apply the filter on Sheets/ State of the sheet?

Thank you 

[Kushal_Chawda]

@l26b  You can concatenate both the tables in load script with the flag. You can then utilize that Flag either as a filter or set analysis condition in measure to restrict current or historic data

Current:
LOAD *,
     'Cuurent' as Flag
FROM current_table;

concatenate
LOAD *,
     'Historic' as Flag
FROM Historic_table;

[l26b · Accepted solution]

how  I can create this Flag to be used in the metrics but not be seen as a Filter in the app? I do not want it to be displayed as a possible selection option

[madelonjansen · Accepted solution]

@Kushal_Chawda Nice solution.

@l26b You can tag the field as $hidden, or set a hideprefix/suffix for the fieldname

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/field-tags.htm

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemVariables...

[l26b]

Thank you so much for this solution, it is working!

In Order to avoid Synthetic Keys would it be better to use Concatenate or No Concatenate function?