Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JayakumarNaganathan
Contributor II
Contributor II

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

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:

JayakumarNaganathan_0-1691067014573.png

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.

3 Replies
G3S
Creator III
Creator III

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
Contributor II
Contributor II
Author

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
Creator III
Creator III

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...