Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist 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
sunny_talwar

16 Replies
vinieme12
Champion III
Champion III

You can directly use MEDIAN(TIME) as expression

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
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
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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.