Discussion Board for collaboration on QlikView Scripting.
I have a table loaded like this:
I need to compare in a bar chart sum(value) on year 2019 with sum(value) in 2020
how can I do this ?
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.
View solution in original post
not compltely clear on the issue.
why not add year as a dimension?