topic Re: Create Incremental Graph in QlikView

Create Incremental Graph

Tue, 26 Mar 2013 06:37:53 GMT

Hi,

I need to create a graph which takes incremental values.

As if TABLE1 is as follows:

Name Marks

X 10

A 20

Y 30

The bar graph should show values as follows:

X axis-----Name

Y Axis -----Marks

For X 10

For A 30(10 of X + 20 of A)

FOR Y 60(30 of Y + 20 of A + 10 of X)

Also I have a variable in which Max marks is stored which can vary from time to time.

Need to provide a target line on this graph comparing marks column to value in variable.

Thanks.

Aaditya Motiani

kaushiknsolanki — Tue, 26 Mar 2013 06:50:04 GMT

Hi,

Create a Bar chart with the dimension as Name and expression as Sum(Marks)

In expression tab you will find the setting for Accumulation. Click on Full Accumulation.

This will solve your problem.

Regards,

Kaushik Solanki

Tue, 26 Mar 2013 07:18:58 GMT

thanks