Qlik Community

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
krishna20
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

Re: Claculating median for background color expression

16 Replies
Highlighted
vinieme12
Esteemed Contributor II

Re: Claculating median for background color expression

You can directly use MEDIAN(TIME) as expression

Highlighted
vinieme12
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

Re: Claculating median for background color expression

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

Highlighted

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
krishna20
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.

Please suggest accordingly.

Highlighted
krishna20
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
krishna20
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

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
krishna20
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.