topic Re: Beginner line graphs in QlikView

Beginner line graphs

Mon, 07 Apr 2014 13:20:08 GMT

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.

Re: Beginner line graphs

rustyfishbones — Mon, 07 Apr 2014 13:22:32 GMT

Are you using a licensed version or Personal Edition?

Re: Beginner line graphs

MK_QSL — Mon, 07 Apr 2014 13:23:25 GMT

Create a line graph

Take Dimension = Month

Expression

SUM(Fraction of Total)

Tick Relative ...

Re: Beginner line graphs

Mon, 07 Apr 2014 13:24:55 GMT

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

Re: Beginner line graphs

rustyfishbones — Mon, 07 Apr 2014 13:29:59 GMT

Choose Line Chart

Select Month as the Dimension

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

Re: Beginner line graphs

Mon, 07 Apr 2014 13:33:17 GMT

Thanks that worked.