If user select 1 value, it should bring relevant record for that selected value along with 2 default values relevant records without user selection.

[JayakumarNaganathan]

Load full table data via script from BQ.

From the report, If user selected 1 value, it should bring that relevant record for that selected value. Along with 2 default values relevant records without user selection

Refer the below image:

Scenario 1: After full table data are loaded via script from BQ

As a User, From the column 'Filter column 2' - Selected the value as 2023-03

Expected output:  For the selected value 2023-03 it should bring 'AU' along with default values (0, STC) without user selection and the output should be like AU, DEF1 & DEF2

Scenario 2:

As a User,  From the column 'Filter column 2' - Selected the value as 2021-01

Expected output: For the selected value 2021-01 it should bring 'AO' along with default values (0, STC) without user selection and the output should be like AO, DEF1 & DEF2 

Need Qlik Sense Expert support - To resolve the user request.

[G3S]

if the selection is to be made from a filter and the results are in table (and this 0, STC etc are fixed values) , you could do a set analysis in the results table - to look for records that match the filter selection and also equal to 0, STC.

[JayakumarNaganathan]

Sorry to ask this. How & where to do this set analysis in the results table.

My report is loaded with full table dat. So, from the respective column value I need to match the filter selection and also equal to 0, STC

[G3S]

in a straight table for example, if you add your calculation as a measure column. then edit the calculation. that is where you would have the set analysis. 

or you could try this as a master measure. 

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFunct...

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...