Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to apply selection from two fields as one selection field.

I want to make some kind of favorite table..

there is an original table chart that has all values.

table_A:

LOAD * INLINE [

all

a,

b,

c,

d,

e,

f,

g

];

and another table chart that has only favorite values.(I load this table with hard coding)

table_Favorite:

LOAD * INLINE [

favorite

a,

d,

g

];

and made 2 table chart for those two tables and one bar chart to show information about selected alphabet on the sheet.

and apply selection to the bar chart from both  [table_A] and [table_Favorite].(only one selection is available from one of those tables, with table_As' field name as a selection field)

I put below expression inside Add-ons>Data handlig>Calculation condition.

GetSelectedCount([all])=1

But don't know which data to put in the table chart for favorite list(values that only exist in table_Favorite).

2 Replies
vinieme12
Not applicable

Re: How to apply selection from two fields as one selection field.

Load like below

table_A:

LOAD * INLINE [

all,Favorite

a,a

b,

c,

d,d

e,

f,

g,g

];

If you maintaining a list separately then , load your Table_A and then Left Join Hard coded list and keep a single table

table_A:

LOAD * INLINE [

all

a

b,

c,

d

e,

f,

g

];

Left Join(table_A)

Fav:

Load * inline [

all,Fav

a,a

d,d

g,g

];

Not applicable

Re: How to apply selection from two fields as one selection field.

If I merge, can I make table of 'all' that has 'Fav' value?