Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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