topic Two different filters in two sheets in the same app in App Development

Two different filters in two sheets in the same app

l26b — Wed, 13 Nov 2024 09:18:27 GMT

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

Re: Two different filters in two sheets in the same app

Kushal_Chawda — Wed, 13 Nov 2024 09:27:24 GMT

@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;

Re: Two different filters in two sheets in the same app

l26b — Wed, 13 Nov 2024 10:13:31 GMT

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

Re: Two different filters in two sheets in the same app

madelonjansen — Wed, 13 Nov 2024 10:18:34 GMT

@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/HidePrefix.htm

Re: Two different filters in two sheets in the same app

l26b — Wed, 13 Nov 2024 13:05:38 GMT

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?