Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Specialist
Specialist

Line chart with value in percentage of first month

In this simplified example I have Year and Month as dimension and sum(value) as expression.

Now I want to have the sum(value) displayed as a percentage of the first month.

When I have a table-chart it can be done by showing the absolute value and use the the function before, but I cannot get it done in a line chart, in which I only want to show the percentage.

Please see example

 

1 Solution

Accepted Solutions
curiousfellow
Specialist
Specialist
Author

Think  I solved it:

 

sum(value)

/

sum( {<month={1}>} TOTAL <year>value )

View solution in original post

5 Replies
bharathadde
Creator II
Creator II

Try this

=sum(value)/sum(total value)

curiousfellow
Specialist
Specialist
Author

Total would give me the total of all months I think, and should be the total of the first month of the year

bharathadde
Creator II
Creator II

This will work

=(sum(value)/sum(Total <month>value))*100

curiousfellow
Specialist
Specialist
Author

(Total <month>value)) will give me the sum for every month number. I need the sum of the first month per year

curiousfellow
Specialist
Specialist
Author

Think  I solved it:

 

sum(value)

/

sum( {<month={1}>} TOTAL <year>value )