Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
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
You can directly use MEDIAN(TIME) as 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
Do you only have Team as your dimension or do you have more dimensions?
May be you need something like this in case you have more than one dimension in your chart
Median(TOTAL <Team> TIME)
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.
Thanks Sunny for replying. How can I assign the colors for those values. Can you please help me with a sample data or app.
Hi ,
I need to represent the colors based on the formula as I attached the screenshots.
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?
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.