topic Re: Filter Data in QlikView

Filter Data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Filter Data

ychaitanya — Wed, 11 Apr 2018 15:19:03 GMT

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

Re: Filter Data

Anonymous — Wed, 18 Apr 2018 02:02:27 GMT

Hi Chaitanya

Thanks for your reply.

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

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

Re: Filter Data

sudhirpkuwar — Wed, 18 Apr 2018 05:39:05 GMT

It will also include Sales data for Year 2018

Re: Filter Data

ychaitanya — Wed, 18 Apr 2018 13:27:03 GMT

rather why can't you use

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