topic Re: Change background colour table, percentage in QlikView

Change background colour table, percentage

Anonymous — Mon, 02 May 2016 11:17:17 GMT

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.

Re: Change background colour table, percentage

Gysbert_Wassenaar — Mon, 02 May 2016 11:30:47 GMT

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

Re: Change background colour table, percentage

Anonymous — Mon, 02 May 2016 11:40:05 GMT

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

Re: Change background colour table, percentage

Gysbert_Wassenaar — Mon, 02 May 2016 11:44:54 GMT

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

Re: Change background colour table, percentage

avinashelite — Mon, 02 May 2016 11:50:54 GMT

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

Re: Change background colour table, percentage

Anonymous — Mon, 02 May 2016 11:51:39 GMT

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.

Re: Change background colour table, percentage

Anonymous — Mon, 02 May 2016 11:52:16 GMT

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

)

Re: Change background colour table, percentage

Anonymous — Mon, 02 May 2016 11:54:55 GMT

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

Re: Change background colour table, percentage

tamilarasu — Mon, 02 May 2016 12:04:15 GMT

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()))

Re: Change background colour table, percentage

Gysbert_Wassenaar — Mon, 02 May 2016 12:06:41 GMT

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.