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.
Can you post a small Qlikview document that demonstrates the problem?
not necessary, i need to know how to change the background colour for collums with percentage%.
Same as any other expression column. Percentages are just numbers with formatting. 1% is 0.01.
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.
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.
how your calculating the % ?? with the use of the Number tab, show % ??
I use this expression;
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
Button object; =If($(vChange)=1,'Vis som Tall','Vis som Prosent')
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()))
Retrieving data ...