Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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.

Highlighted
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)))