topic Re: Arithmetics Operations with Columns(As Dimensions) in QlikView

Arithmetics Operations with Columns(As Dimensions)

DavidS — Wed, 25 Nov 2020 16:16:04 GMT

Hello, i want to create a third column with value of =ciclo1(2017.2018) - ciclo2(2018.2019) and i cant find any related answers. Do someone know how to? Thanks.

Example with 'Comprado' = > 85185-77554 = 7631

image here: https://ibb.co/tpn8gMD

Re: Arithmetics Operations with Columns(As Dimensions)

Arthur_Fong — Wed, 18 Sep 2019 00:11:52 GMT

Can you provide a sample app?

Re: Arithmetics Operations with Columns(As Dimensions)

rwunderlich — Wed, 18 Sep 2019 02:03:25 GMT

You have two options for your third Measure.

1. Use the Column(n) function:

Column(1) - Column(2)

2. Reference the measure labels:

[2017-2018] - [2018-2019]

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Arithmetics Operations with Columns(As Dimensions)

Brett_Bleess — Mon, 30 Sep 2019 14:50:59 GMT

David, did Rob's post help you with what you needed? If so, please be sure to use the Accept as Solution button on his post to give him credit and let others know that it was what you needed and that it worked. If you did something else, consider documenting that for others and then mark that post, and if you still need further help, please provide an update on things.

Regards,
Brett