Discussion board where members can get started with Qlik Sense.
I have a group have 4 subgroup.
I create line chart to have individual group line (sum(Sales) per day)draw out
but I want to have a Group reference Line (Median(all 4 subgroup sale)per day) in the Same graph.
Any suggestion how could I achieve that?
Here is the qvf file in the attachment. Thank you so much!
Go to Solution.
Open this link and I have attached the qvf (twice now)
Re: How could create a Group Median line in the Chart
Is this line going to be a static line? or is that going to change each day?
Now it is static.
But if possible, this will be refresh weekly
Could I have both solutions?
What I meant to ask is that you need Median for each day or Median across all dates and subcategories?
Sorry. did not understand correctly
I want a line (not the straight reference line) have 7 points. and each point represents 1 day for 4 subcategoris' Median
May be create multiple expressions with single dimension?
Sure. this is what i want. How did you do that?
could i have the qvf with function ?
and any chance we can make the Media line --Boarder? or Darker? or change the line shape?. to distinguish from the individual one? (any One methord would be nice)
How about this?
The QVF is attached with this post again (did attach it with my previous response also)
Have used line for marker, but you can chose any other symbol also
Cool. But how did you do that?
what things i need to do? could you attach the qvf please? or teach me how to do that?