Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
KIdriss
Contributor II
Contributor II

Get the first value of sum function

Hello,

I would like to know how to compare a value of a yearQuarter compared to the first yearQuarter.

- Dimension: colDate.autoCalendar.YearQuarter

- Measure:  comparison with the reference

I tried this but i get nothing:

( Sum(traf_aer_pax) - Aggr(Sum(traf_aer_pax), periodData.autoCalendar.YearQuarter) ) / Aggr(Sum(traf_aer_pax), periodData.autoCalendar.YearQuarter) 
Labels (1)
0 Replies