Claculating median for background color expression

[krishna20]

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

[vinieme12]

You can directly use MEDIAN(TIME) as expression

[vinieme12]

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

[sunny_talwar]

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

[sunny_talwar]

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

Median(TOTAL <Team> TIME)

[krishna20]

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.

[krishna20]

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

[krishna20]

Hi ,

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

[sunny_talwar]

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?

[krishna20]

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.