Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Using a filter pane to modify chart

Hi all,

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?


Thanks much!

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Using a filter pane to modify chart

Hi, backend, you can create an island table ( not connected to your data model) by using inline load. Best Dan.

2 Replies
Partner
Partner

Re: Using a filter pane to modify chart

Hi, backend, you can create an island table ( not connected to your data model) by using inline load. Best Dan.

guitartrova
Contributor III

Re: Using a filter pane to modify chart

Try

For example

LOAD * INLINE [

    CUST_NAME, STATUS  

    A, PASS

    B, FAIL

    C, PASS

    D, FAIL

     E, PASS

    F, FAIL

    G, PASS

    H, FAIL

];

[measure_names_real]:

load * inline [

   measure_real

    PASS,

    FAIL

];

Expression :

if( only(measure_real)='PASS', count(STATUS),

if( only(measure_real)='FAIL', count(STATUS)))