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: 
Robert78
Contributor III
Contributor III

sum of values of different rows

Hi guys,

I have a table loaded like this:

Year/Month/Value

2019/1/4324

2019/2/4335

...

2020/1/43543

2020/2/45454

...

I need to compare in a bar chart sum(value) on year 2019 with sum(value) in 2020

how can I do this ?

pls advice.

thanks.

Labels (1)
1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

so load

Data:

load

subfield(Datafield,'/',1) as Year,

subfield(Datafield,'/',2) as Month,

subfield(Datafield,'/',3) as Value

from your datasource;

and then create a bar chart,

Year as dimension, sum(Value) as extression.

Regards

 

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

not compltely clear on the issue.

why not add year as a dimension?

martinpohl
Partner - Master
Partner - Master

so load

Data:

load

subfield(Datafield,'/',1) as Year,

subfield(Datafield,'/',2) as Month,

subfield(Datafield,'/',3) as Value

from your datasource;

and then create a bar chart,

Year as dimension, sum(Value) as extression.

Regards