topic Re: Background Color in QlikView

Background Color

Anonymous — Fri, 11 Mar 2016 00:41:19 GMT

Can someone help me in fixing this , the Background color is getting complicated with the complex expression and alternate states I have ..

I want the below logic , can I get this with the columns numbers or names of expressions instead of using the complete expressions ? I should not see any white in background color.

FCI Status:

If ( FCI % > SLA FCI , RED() ,

If(SLA FCI is Null , Red(),

If(FCI% < SLA FCI, GREEN)

TP99 Status

If ( TP99 > SLA_TP99 , RED() ,

If(TP99 is Null , Red(),

If(TP99 < SLA_TP99, GREEN)

Thanks!

Re: Background Color

jagan — Fri, 11 Mar 2016 01:45:32 GMT

HI,

First of all move all numeric fields to expressions and the you can easily use this expressions in color expressions.

You can use expression names in the color expressions

If ( [FCI %] > [SLA FCI] , RED() ,

If([SLA FCI] is Null , Red(),

If([FCI%] < [SLA FCI], GREEN())))

Regards,

Jagan.

Re: Background Color

Saravanan_Desingh — Fri, 11 Mar 2016 01:57:52 GMT

If([FCI %]>[SLA_FCI],

Red(),

If(IsNull([SLA_FCI]),

Red(),

If([FCI %]<[SLA_FCI],Green()

)

Yes, as Jagan said, we can use Expression Names. Visual Cues wont be helpful if you have complex Expression for defining Background.

Re: Background Color

Anonymous — Fri, 11 Mar 2016 02:23:26 GMT

I don't want to move dimensions to expressions because its getting complicated to have all those dimensions with only expressions , and also most of them show 0 if I use them in expression , this way I get the data correct and also my filters selections working well ... I tried that before ...

Re: Background Color

Digvijay_Singh — Fri, 11 Mar 2016 02:46:56 GMT

Can you share your dimensions and expressions, based on that it can be verified whether expression name can be used or not, they need to be available first before we use in bk color. May be I misunderstood the req.

Re: Background Color

Anonymous — Fri, 11 Mar 2016 02:51:17 GMT

I attached the app , date , function and fci group are dimensions rest all expressions..

Re: Background Color

Anonymous — Fri, 11 Mar 2016 04:10:45 GMT

I have modified the expression , but still I could 1 values with White() , attached the document !