Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.