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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
michael_maeuser
Partner Ambassador
Partner Ambassador
‎2013-03-26 05:13 AM

Aggr over caluculated dimension

Hello,

I have a Pivot Table with 3 dimensions. 1 dimension is a consists of an if-statement. Since QV once again gives me wrong sum in my expression, I want to do an SUM(AGGR( over all dimensions to influence the total sum. Is it possible to make an aggr over a calculated dimension? my dimension is

=if (A='Bis',vLastDayPreviousMonth,date(Date))

Thank you.

Br, Michael

235 Views
0 Likes
0 Replies