topic Re: Comparison of values in QlikView

Comparison of values

vkozlov — Fri, 10 Jun 2016 05:10:48 GMT

Good day, team!

Help me somebody

What method can be used to compare values obtained by the example in Table:

dimensions: Year, CompanyName

expression- sum of sales

Need to get the difference of sales amounts for each related period (example: difference between 2008 and 2007; 2009 and 2008 etc.)

There is an idea to build a table with several expressions:

=Sum({<Year={2007}>}LinesalesAmount)

=Sum({<Year={2008}>}LinesalesAmount)

=Sum({<Year={2008}>}LinesalesAmount) - Sum({<Year={2008}>}LinesalesAmount) // difference

etc.

But it seems that the decision irrational because with a large variety of Year - to be a lot of routine work

oknotsen — Sun, 12 Jun 2016 11:10:04 GMT

You could try this:

column(1) - column(2)

Sun, 12 Jun 2016 11:22:35 GMT

Maybe try this one:

sum(Value)-Before(sum(Value))

Athough it will work only if Year will be in the columns headers

vkozlov — Sun, 12 Jun 2016 11:35:44 GMT

Thanks!

It works