Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore Selection and calculate with full Year (excl. last year)

Hi all

I use following formula to calculate our revenue based on users selection.

Num(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), '#''##0.00')

for some other calculations I need the full year figure by ignoring users selection, but it should take only current year and ignore last year.

how can I integrate that?

0 Replies