topic Text Object using set expression in QlikView

Text Object using set expression

jagdishbr — Sat, 16 Nov 2024 20:27:22 GMT

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.

Re: Text Object using set expression

Lisa_P — Mon, 15 Jul 2019 05:55:19 GMT

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

Re: Text Object using set expression

jagdishbr — Mon, 15 Jul 2019 06:22:54 GMT

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.

Re: Text Object using set expression

Lisa_P — Wed, 07 Aug 2019 23:09:42 GMT

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.