Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Calculations between subgroups of a dimension

Hello

I currently have my 2016 Data, budget and past years in a dimension called Origin.

Im using a pivot table to see results,but i want to make calculations between this fields.

Any Clues?

example.jpg

4 Replies
MVP
MVP

Re: Calculations between subgroups of a dimension

It might be useful if you provided some clues on what you would like to calculate...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
brunobertels
Valued Contributor II

Re: Calculations between subgroups of a dimension

Hi

you can make calculation between this fields by using the before() function :

mesure :

may be :

sum(MONTO MILES) - before(sum(MONTO MILES))

Not applicable

Re: Calculations between subgroups of a dimension

@

Jonathan Dienst (a abel abad) hace 9 horas

It might be useful if you provided some clues on what you would like to calculate...

Im just looking to make this formulas :

Real 2016 / Budget 2016

Real 2016-Budget 2016

Real 2016 / Real 2015

MVP
MVP

Re: Calculations between subgroups of a dimension

And how are the values Real 2016/2015 and budget 2016/2015 calculated? The value of responses you get will be directly proportional to the amount of information you provide.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein