topic Re: Need to highlight the substring in blue color as below example in QlikView

Need to highlight the substring in blue color as below example

sharu055 — Tue, 02 Aug 2022 14:41:21 GMT

Hi,

I am having the input string as below i need the output that particular last word must be in blue color as below output please help,

Input

As sweet as Apple

As sweet as Honey

As sweet as Sugar

As sweet as Mango

As sweet as Water

As sweet as Apple

As sweet as Water

As sweet as Grapes

Output:

Please help.

Re: Need to highlight the substring in blue color as below example

marcus_sommer — Tue, 02 Aug 2022 15:28:20 GMT

Within a single cell or a text-box or similar you could have only one formatting for everything. This means you need to distribute it to multiple cells - maybe two columns side by side or maybe another method to highlight a certain content, like: As sweet as APPLE.

- Marcus

Re: Need to highlight the substring in blue color as below example

sharu055 — Tue, 02 Aug 2022 15:57:02 GMT

Hi Marcus,

@marcus_sommer I need in a single column, As Sweet as APPLE. But APPLE must be in Blue color, as i need to use in straight table.

Please help

Re: Need to highlight the substring in blue color as below example

marcus_sommer — Tue, 02 Aug 2022 16:07:36 GMT

Like above mentioned it's not possible - at least not with a single column. Thinkable is the use of an extension - but I don't know an existing one and I doubt that it would be worth the needed efforts.

- Marcus

Re: Need to highlight the substring in blue color as below example

sharu055 — Tue, 02 Aug 2022 16:14:42 GMT

@marcus_sommer Could you please help me how to do it in side by side column as per your first reply

Re: Need to highlight the substring in blue color as below example

marcus_sommer — Wed, 03 Aug 2022 06:26:42 GMT

You could for example use something like:

left(Field, index(Field, ' ', -1))

for the first column and

subfield(Field, ' ', -1)

for the second one to split the field-values appropriate and the first column will be right aligned and the second left aligned - and sizing the widths of columns. And by a right click on the second column and calling the option of custom format you could adjust the color of the left border to your background-color or maybe making it transparent with argb(0,0,0,0). The blue string-color could you set per attribute-expression (the small + signs by the dimensions/expression and choosing adding by text-color = blue().

- Marcus

Re: Need to highlight the substring in blue color as below example

sharu055 — Mon, 08 Aug 2022 18:16:29 GMT

@marcus_sommer Could you please help to below question.

I have 3 columns in straight table. Team, Date, Result. Need the Sorting that Result column as primary sort that only only Won, Lost should appear as first and Tie, No Result should come second and Date column should be as secondary sort where old dates should comes at first as ascending. below are my input n needed output. please help

Input:

Team	Date	Result
IND	5/25/2022	Lost
CHI	5/15/2022	Tie
UK	4/22/2022	Lost
IND	4/31/2022	Won
UK	5/3/2022	No Result
USA	4/30/2022	Tie
CHI	5/31/2022	Won
USA	6/1/2022	No Result
UK	6/30/2022	Lost

After Sort Output need as below :

Team	Date	Result
UK	4/22/2022	Lost
IND	4/31/2022	Won
IND	5/25/2022	Lost
CHI	5/31/2022	Won
UK	6/30/2022	Lost
USA	4/30/2022	Tie
UK	5/3/2022	No Result
CHI	5/15/2022	Tie
USA	6/1/2022	No Result

Please help.

Re: Need to highlight the substring in blue color as below example

marcus_sommer — Tue, 09 Aug 2022 06:30:44 GMT

Your wanted sorting-order isn't quite clear for me unless you want to sort not only for columns else the values of multiple columns in combination in a way that they would exclude each other on a column-level.

In such a case you need to combine the columns within the sorting. The easiest way is usually to make all the values numeric and then to sum them. This means all string-values get also a numeric value, for example like:

pick(match(Result, 'Lost', 'Won', 'Tie', 'No Result'),
dual('Lost', 9), dual('Won', 7') dual('Tie', 8)', dual('No Result', 0)) as Result

and within a sorting expression from the chart you may apply:

rangesum(Date * 10, num(Result))

Like mentioned above I didn't understand your ordering and therefore the result from this example may not fit for it - but the logic to sum/subtract the values with a more or less large multiplication/division to one column to ensure that the rangesum-results couldn't overlap will work. Such playing with logic and algorithm is usually in a tool like Excel easier and faster as within a BI tool or a data-base - Just try it.

- Marcus