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: 
Anonymous
Not applicable

Filter Data

Hi All

I am very new to QlikView. I want to filter the data using set analysis. What would be the set expression, if I want to filter Sum(Sales) from year 2000 to 2017?

Thanks.

Regards:

Divya

4 Replies
ychaitanya
Creator III
Creator III

Sum({<Year={">=2000 <= 2017"}>}Sales)

Anonymous
Not applicable
Author

Hi Chaitanya

Thanks for your reply.

Would it be right to write the set expression     Sum({<Year={">=2000 <= 2017"}>}Sales)

as

Sum( { < Year= { "2*"} > } Sales)

sudhirpkuwar
Partner - Creator II
Partner - Creator II

It will also include Sales data for Year 2018

ychaitanya
Creator III
Creator III

rather why can't  you use

   Sum({<Year={">=2000"}>}Sales)