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