Change background colour table, percentage

[Anonymous]

Hi,

I have created a "Show number in % percent button", but when i klikk on it the colours goes from red to white. See attached.

i cant find the right solution to fix the percentage collums.

i want >0,5% <0,5% show red. 

[Gysbert_Wassenaar]

Can you post a small Qlikview document that demonstrates the problem?

[Anonymous]

not necessary, i need to know how to change the background colour for collums with percentage%.

[Gysbert_Wassenaar]

Same as any other expression column. Percentages are just numbers with formatting. 1% is 0.01.

[avinashelite]

how your calculating the % ?? with the use of the Number tab, show % ??

[Anonymous]

New problem;

When i switch from percentage to regular numbers every collum turns red.

I have change the visual cues, but like i said i need to change the background colour to the expression with a code.

[Anonymous]

I use this expression;

if(vChange=1,

    num(sum(pick(match(Målepkt_Gruppering, 22), kWhVG)) - sum(kWh),'##0'), //numbers

    num((sum(pick(match(Målepkt_Gruppering, 22), kWhVG)) - sum(kWh))/sum(kWhVG) ,'##,#%') //percentage

)

[Anonymous]

Button object; =If($(vChange)=1,'Vis som Tall','Vis som Prosent')

[tamilarasu]

You can try background color expression instead of visual clues.

if(vChange=1 and [Diff HM-UM]>5 and [Diff HM-UM]<-5, Red(), If

([Diff HM-UM ]>5% and [Diff HM-UM]<-5%, Red()))

[Gysbert_Wassenaar]

Click on the + in front of the expression, choose Background Color and enter an expression that calculates the color. Something like =If( ...some_condition..., Red(), Blue() ). Adapt as necessary.