Custom Format Cell not working in Table Box

ZoeM — Sat, 16 Nov 2024 19:10:13 GMT

Hi Team!

Hey I have a simple but weird one.

I have created a table box (because I need the Input Field option) and I want to custom format the dimension backgrounds. I have created several different table boxes and none of them are recognizing the desired outcome.

Please see attached and help me identify where I am mistaken.

Thanks!

Re: Custom Format Cell not working in Table Box

rubenmarin — Sat, 08 Feb 2020 09:46:32 GMT

Hi, if a field have difffrent values it returns null, you need an aggregation funcion to eturn only one value: Concat(), MaxString(), in example to look if there is a value in all possible values you can make a concat to mrge all values in a single value and search the value in a sting, in a simple way it can be like:

If(SubStringCount(Concat(Color),'Green'),Green())

Also, you can use a table chart with hidden expression to apply a different color to each row in the same column, sample attached.

topic Custom Format Cell not working in Table Box in QlikView

Custom Format Cell not working in Table Box

Re: Custom Format Cell not working in Table Box