Filter Data

[Anonymous]

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

[ychaitanya]

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

[Anonymous]

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]

It will also include Sales data for Year 2018

[ychaitanya]

rather why can't  you use

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