topic Re: Text on Axis Coluring for certain conditions in QlikView

Text on Axis Coluring for certain conditions

spikenaylor1 — Sat, 16 Nov 2024 18:39:14 GMT

I have expression showing as text on axis

I need to colour this text based from a list of Batch numbers to indicate new data for chart

I NoConcatenate Load a list of Batches that need to be highlighted as new batches for the monthly report

on the Text Colour part of the expression

my formula is

= If(substringCount(GetFieldSelections(Batches_to_Include),Batch)>0,Brown(),LightGray())

Selecting any Batch from the Batches-to-Include list colours the text brown

selecting any combination colours text brown

selecting all of the list fails, no brown colouring

cant work out why this is

any advice greatly received

Many thanks for looking

tresB — Wed, 13 May 2020 10:27:37 GMT

Could you share a sample app and explain the expected output in that context?

spikenaylor1 — Wed, 13 May 2020 11:13:14 GMT

quicker to use photos

Please see photos below for what happens

No Selections made

No Selections Made

Some Selections made

All but one selected

All selected

All Selected

tresB — Wed, 13 May 2020 11:28:42 GMT

What if you try like:

= If(substringCount(GetFieldSelections(Batches_to_Include, '|', 100),Batch)>0,Brown(),LightGray())

spikenaylor1 — Wed, 13 May 2020 12:14:35 GMT

Many Thanks

that sorted it

Regards