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

Set analysis and adding an absolute value to only one year

Hello,

I have an object which goes as follows:

=Sum ( {<[Financial Year]={$(vYears)}>} [Amount])

The variable 'vYears' has two values: 2012 en 2013.

The result is the sum(Amount) for 2012 and 2013.

Now I want to add 1000 only to the year 2012.

I con't figure out how. Any Help?

Thanks!

Message was edited by: Jasper de Vries

12 Replies
Not applicable
Author


Thanks guys!

All of the solutions worked!

I rated the first as the 'Correct answer', the rest as (very) 'Helpful Answers'.

Not applicable
Author

Thanks for the effort QlikPhadi07. I just rated the other answers and apparently I can only mark 2 answers as 'Helpful', but yours does the trick as wel.

qlikpahadi07
Specialist
Specialist

No issues Jasper but yes you can like the answer enough for me .

Happy Qlicking