Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

how to represent a pie chart as a line graph

I'm new to Qlik and have a requirement to represent a pie chart output as a line graph.  So for each piece of pie there would be an individual line on the line graph with all lines adding up to 100% each day.

DateEventTotal Minutes
7/1/16Down

30

7/1/16Ready100
7/1/16Working250
7/1/16Setup50

The pie chart would have 4 pieces that would add up to 100%.  In this case the Line chart would have 4 points on 7/1 that would add up to 100%.  The Line Chart should look like the following.

LineGraph.png

Any ideas?

Thanks,

Mark

1 Reply
MVP
MVP

Re: how to represent a pie chart as a line graph

Try creating a line chart with two dimensions Date and Event and one expression:

=Sum([Total Minutes]) / Sum(TOTAL<Date> [Total Minutes])

Community Browser