Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

not compltely clear on the issue.

why not add year as a dimension?

Highlighted
Partner
Partner

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