Beginner line graphs

[#1]

Hello everyone,

I'm totally new to Qlik View and am interested in bringing in data from a variety of sources and making a workbook with several different line graphs. I have been working with a dummy excel file trying to get the graph functionality to work and have been unsuccessful - I think it may have to do with the way that I set up the fields in the excel file (which is attached). What I would like to do is plot the month on the x axis of the graph, and then plot the (fraction of total / total) as a percentage with respect to its corresponding month. Would somebody be able to help me do this? Thanks.

[rustyfishbones]

Are you using a licensed version or Personal Edition?

[MK_QSL]

Create a line graph

Take Dimension = Month

Expression

SUM(Fraction of Total)

Tick Relative ...

[#4]

Right now I'm using the personal one but I will eventually be using the licensed small business version.

[rustyfishbones · Accepted solution]

Choose Line Chart

Select Month as the Dimension

and SUM([Fraction of Total]) as the Expression, tick the relative tick box

[#6]

Thanks that worked.