Text Object using set expression

[jagdishbr]

Hi, 

I'm new to qlik and trying build a dashboard where i need to show client category in a text object for different region

Example

on Selection of Client below values should appear in a text object. i have created a 4 text objects in a dashboard. for example Text Object Header is " MENA" and Text = Gold

MENA : Gold

APAC: Silver

CEEMEA: Gold

EMEA: Platinnium

CEEMEA: Bronze

I tired achieving this through using MaxString, MinString function in a set Expression but it fails. sometime it give accurate sometime not.

=MaxString({$<Region={'MENA'}>} CATEGORY)

=MaxString({$<Region={'APAC'}>} CATEGORY)

=MaxString({$<Region={'CEEMEA'}>} CATEGORY)

=MaxString({$<Region={'EMEA'}>} CATEGORY)

Can you please throw some light where am i going wrong or some suggestion.

[Lisa_P]

It's not clear how this is relating to your data. Can you please explain more

[jagdishbr]

Thanks Lisa

I have data in excel and importing data through load statement, we trying relate sales and their existing category.

have created Text Object for each region. on Selection of a client from list box filter, relevant category should appear in text object

Client Name              Region                   Category

A                                    MENA                      Gold

A                                    APAC                        Platinum

A                                    EMEA                        Gold

A                                     CEEMEA                Bronze

A                                     Americas              Silver

B                                    MENA                      Platinum

B                                    APAC                        Platinum

B                                    EMEA                        Gold

B                                     CEEMEA                Platinum

B                                     Americas              Silver

C                                   MENA                      Gold

C                                    APAC                        Gold

C                                    EMEA                        Gold

C                                     CEEMEA                Bronze

C                                     Americas              Silver

Hope i have explained.

[Lisa_P]

It should be simpler than that. 

For the text object, use the expression:

=only(Category)

This will select the possible Category when client is selected.