topic Re: Error in Background color using set analysis with data out of selection in QlikView

Error in Background color using set analysis with data out of selection

Wed, 26 Mar 2014 18:17:16 GMT

Hello everyone

I´m trying to format with color (Background ant text) dimensions and expresions in a chart table.

Everything is OK but when in I use an expresion with set analysis to get information that is not in the current selection, I loose this format

I send you an example of an app. Does anyone know how to keep the Background and Text Color

Thanks in advance

Re: Error in Background color using set analysis with data out of selection

maxgro — Wed, 26 Mar 2014 22:48:47 GMT

try with (1 Orden for row)

=if(only({1}Orden)=1,RGB(255,102,0),

if(only({1}Orden)=2,RGB(192,192,192),

if(only({1}Orden)=3,RGB(0,0,0),

if(only({1}Orden)=4,RGB(255,102,0),

if(only({1}Orden)=5,RGB(192,192,192),

)))))

in expression and on first dimension only

Re: Error in Background color using set analysis with data out of selection

Wed, 26 Mar 2014 23:52:25 GMT

Hello Massimo,

thank you for your reply. It works but since I have a report with a lot of rows (each Orden number is a row) I created 2 tables (BackgroundColor and TextColor) linked with the Report Table in wich I include for each row the 2 fields

No my statement in the background and text script is as follows

=RGB(ColorFondo_R, ColorFondo_G, ColorFondo_B)

In each row of the report table I include the color that matches with the RGB color. It works fine in the first chart, but have the same problem un Chart 2 when I select the field Empresa2 and the chart have a set analysis that gets information out of current selection. In the expresion I have:

sum ({1 <Empresa={'Empresa1', 'Empresa2'}>}(Importe))

Do you know how to fix this issue so I don´t have to put and RGB format for each row since I design them in the report??

Thank you in advance