topic Re: Colors in font (inline table) in QlikView

Colors in font (inline table)

Wed, 06 Jan 2016 13:54:53 GMT

I have an inline table like this

AD_HOC:

LOAD * INLINE [

_DIMENSIONADHOC, ID_DIM

ID DM, 1

Regional, 2

UUNN, 3

Centro, 4

Equipo, 5

];

The thing is that i wanna separate ID DM and Regional from the others three.

I'd like for example to have in different colors the font

i tried in the colors of the font if id > 2 red, black or something like that but i didn´t work

what do you think?

Cheers!

Re: Colors in font (inline table)

marcus_sommer — Wed, 06 Jan 2016 14:15:25 GMT

Maybe this is helpful: Colors in charts

- Marcus

Re: Colors in font (inline table)

sunny_talwar — Wed, 06 Jan 2016 14:16:49 GMT

Seems to be working here:

Re: Colors in font (inline table)

Wed, 06 Jan 2016 14:22:56 GMT

Thanks but i think i didn't make myself clear

I wanna see the inline with colors in the font!

Re: Colors in font (inline table)

Wed, 06 Jan 2016 14:23:02 GMT

Thanks but i think i didn't make myself clear

I wanna see the inline with colors in the font!

Re: Colors in font (inline table)

sunny_talwar — Wed, 06 Jan 2016 14:25:24 GMT

In the script you mean?

Re: Colors in font (inline table)

marcus_sommer — Wed, 06 Jan 2016 14:25:45 GMT

You mean within the script-editor?

Re: Colors in font (inline table)

Peter_Cammaert — Wed, 06 Jan 2016 14:29:48 GMT

Post a screenshot of what exactly you want to see. You can simulate expected output pretty well in Excel.

Re: Colors in font (inline table)

Wed, 06 Jan 2016 14:35:01 GMT

no, sory for the short explanation

in a list table like this

Re: Colors in font (inline table)

Wed, 06 Jan 2016 14:35:19 GMT

in a list table like this!

Re: Colors in font (inline table)

marcus_sommer — Wed, 06 Jan 2016 14:40:35 GMT

AFAIK it's not possible within a listbox. But if you used instead of a listbox a pivot like in this example Building a nicer, dynamic QlikView multibox The Qlik Fix! you could apply your colors within the attribut-expressions (for how to - see also the link in my answer above).

- Marcus

Re: Colors in font (inline table)

Peter_Cammaert — Wed, 06 Jan 2016 14:44:27 GMT

Marcus suggested to use a pivot table. A normal straight table can also be used to simulate a listbox and list vlaues in different colors. See Re: Wanted to use single color format for all dashboards, Please help