Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
DavidS
Contributor
Contributor

Arithmetics Operations with Columns(As Dimensions)

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

3 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Can you provide a sample app?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

 

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.