Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

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

2 Replies
sunny_talwar

May be this

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

livio218526
Creator
Creator
Author

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