Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

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!

1 Solution

Accepted Solutions
dberkesacn
Partner - Creator III
Partner - Creator III

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

2 Replies
dberkesacn
Partner - Creator III
Partner - Creator III

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

MarioCenteno
Creator III
Creator III

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