Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

Calulate Delta from a dimension

Hi Everyone,

I have a file with different value. I'd like to have a delta from a dimension depending on another dimension (Scenario).

For example:

Scenario          Output

ACT2017         20

FORE2017      40

ACT2017         90

FORE2017      10

I want in ouptu this:     ACT2017-FORE2017 ---> 60

Thanks,

Livio

Tags (2)
2 Replies
MVP
MVP

Re: Calulate Delta from a dimension

May be this

Sum({<Scenario = {'ACT2017'}>}Output) - Sum({<Scenario = {'FORE2017'}>}Output)

livio218526
Contributor

Re: Calulate Delta from a dimension

No, in this way i'm able to see the result only in the Totals, but I want a field only with the delta's value so i can use it for chart.

Thanks