Calculate Average in Column level

[marishnagendran]

Dear All,

Last 5 days	Qty
01/03/2020	20
02/03/2020	40
03/03/2020	20
04/03/2020	10
05/03/2020	25
06/03/2020	10

I want to color the column 1(Qty) based on average of last 5 days.

I.e

Avg is 21

will compare with each column and change the background of color.

[NitinK7]

Hi

try the following steps

1 .write your expression 

2. expand expression (click + sign)

3. select background color option

and write below expression

if(qty>=ceil(Avg( TOTAL Qty)),Green(),White())

find below screnshot.

[marishnagendran]

Thanks for your response

I'm asking in Qliksense. The expression is not working

[marishnagendran]

It is possible in Qliksense or not?????

[NitinK7]

Hi,

as of now it is not possible in qliksense .

but it might be possible using table chart extension 

Regards,

Nitin.

[NitinK7]

sorry my bad

it is possible in qliksense ( november 2019)

see below screenshot , write your expression in background color property

expression like

if ( qty >= ceil ( Avg ( TOTAL Qty) ), Green(), White() )

regards,

Nitin.

[marishnagendran]

We are using Qliksense November 2019 version.

But expression not working.

[marishnagendran]

Kindly share that extension link.

[NitinK7]

Hi

it is not a extension,

it is a simple straight table chart

expand your expression (Measure)  then you will able to see this option

[NitinK7]

hI

see the below screenshots

Expression -

if(Qty>=Avg(Total Qty),Green(),White())