Discussion board where members can get started with Qlik Sense.
I have a chart that I want to read data from different tables depending on a selection by the user.
I wanted to add a filter pane with two values, and then use something like if(getFieldSelections...) to show data from one table or another in the chart.
Where should I create that field with two possible values? In the load script? How?
Or should this be a master item dimension? Or a variable?
Go to Solution.
Hi, backend, you can create an island table ( not connected to your data model) by using inline load. Best Dan.
View solution in original post
LOAD * INLINE [
load * inline [
if( only(measure_real)='PASS', count(STATUS),
if( only(measure_real)='FAIL', count(STATUS)))