Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangcelinexu
Contributor

How could create a Group Median line in the Chart

Hi,

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.

Screen Shot 2017-11-01 at 15.21.54.png

Any suggestion how could I achieve that?

Here is the qvf file in the attachment. Thank you so much!

Regards,

Celine !

Tags (3)
1 Solution

Accepted Solutions

Re: How could create a Group Median line in the Chart

Open this link and I have attached the qvf (twice now)

Re: How could create a Group Median line in the Chart

Capture.PNG

13 Replies

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?

yangcelinexu
Contributor

Re: How could create a Group Median line in the Chart

Now it is static.

But if possible, this will be refresh weekly

Could I have both solutions?

Thank you!

Re: How could create a Group Median line in the Chart

What I meant to ask is that you need Median for each day or Median across all dates and subcategories?

yangcelinexu
Contributor

Re: How could create a Group Median line in the Chart

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

Re: How could create a Group Median line in the Chart

May be create multiple expressions with single dimension?

Capture.PNG

yangcelinexu
Contributor

Re: How could create a Group Median line in the Chart

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)

Re: How could create a Group Median line in the Chart

How about this?

Capture.PNG

The QVF is attached with this post again (did attach it with my previous response also)

Re: How could create a Group Median line in the Chart

Have used line for marker, but you can chose any other symbol also

yangcelinexu
Contributor

Re: How could create a Group Median line in the Chart

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?

Thank you!

Community Browser