Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add filter only 2013 and 2014 from Sum( {$<IsInYTD={1}>} sales )

Hi All

May i know how to modify the expression to remove 2012 ? my expression is shown above ,

remove 2012.png

16 Replies
ashwanin
Specialist
Specialist

Also if you want to check the sum of Sales, then replace IsinYTD with sales in Expression

i.e use      =sum({$<Year ={">=2013"}>} sales)

rustyfishbones
Master II
Master II

Here it is, however, the next time you upload the qvw, you should try to reduce the data to make the file smaller in size.

See the attached file

Regards

Alan

Not applicable
Author

Not applicable
Author

Hi All Thank you for all the reply.

Finally , i need to combine tres and Ashwani :-

=Sum({<IsInYTD={1}, year ={">=2013"}> } sales)

and it work for me.. but not dynamic and yearly need maintenance.

So i modify with sunil code like below , but not able to work , Does any one know how to make it work ?

=Sum({<IsInYTD={1}, Year={$(=year(today())-2)> } sales)

Paul

rustyfishbones
Master II
Master II

you can try this

2014-03-07_1048.png

tresesco
MVP
MVP

This?

=Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> } sales)

Be careful about brackets.

Not applicable
Author

finally this is what i look for. thank tres.