# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Valued Contributor II

## Claculating median for background color expression

Hi Folks,

Sunny Talwar

Gysbert Wassenaar

Marcus Sommer

jagan mohan rao appala

Henric Cronström

We need to calculate median for a column to represent the values with Background color of cells in straight table.

As we know that we are having Median function and those calculations are possible in Excel.

I want to know that the same activity is it possible in Qlikview too?

I am explaining the sample data here.

I am having two columns 'Team' and 'Time', I need to calculate median of 'Time' first and need to allocate a color to it.

A few formulas have been implemented in Excel , the same I need to show in QV for team wise (Low, Medium, High).

PFA sample data and screenshots for the same and advise.

Thanks

Krishna

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Claculating median for background color expression

16 Replies
Highlighted
Esteemed Contributor II

## Re: Claculating median for background color expression

You can directly use MEDIAN(TIME) as expression

Highlighted
Esteemed Contributor II

## Re: Claculating median for background color expression

Refer help section

Median - chart function ‒ Qlik Sense

Stdev - chart function ‒ Qlik Sense

and always search the community for queries first, it will save you time as most of the queries are already answered

Highlighted
MVP

## Re: Claculating median for background color expression

Do you only have Team as your dimension or do you have more dimensions?

Highlighted
MVP

## Re: Claculating median for background color expression

May be you need something like this in case you have more than one dimension in your chart

Median(TOTAL <Team> TIME)

Highlighted
Valued Contributor II

## Re: Claculating median for background color expression

Hi Vinneth,

Thanks for immediate response . I think you have missed something in my sample data.

I need to represent the color for team wise in background color expression.

And as well standard deviation function has been used to represent the colors.

Highlighted
Valued Contributor II

## Re: Claculating median for background color expression

Thanks Sunny for replying. How can I assign the colors for those values. Can you please help me with a sample data or app.

Highlighted
Valued Contributor II

## Re: Claculating median for background color expression

Hi ,

I need to represent the colors based on the formula as I attached the screenshots.

Highlighted
MVP

## Re: Claculating median for background color expression

I mean not entirely sure what you have... but it would be some kind of if condition

If(Expression > Median, Color1, Color2)

Something along those lines, but I don't have a lot of information from you to give you an expression you would need for your case. Do you want to share a sample?

Highlighted
Valued Contributor II

## Re: Claculating median for background color expression

Hi Sunny,

I am attaching here the sample data and I need to implement the same in QV.

Please let me know if you need any further details.