topic Re: Set Analysis Filter in QlikView

Set Analysis Filter

Tue, 09 Feb 2016 09:50:06 GMT

Hi, I wonder if someone can help I currently have an expression that sums the weight based on the delivery year which is set in a variable however I want to filter this data to only display anything bigger than 450,000

this is my current expression : sum({$<DYear = {$(#vYear1)}>} Weight)

thanks in advance

Re: Set Analysis Filter

sunny_talwar — Tue, 09 Feb 2016 09:57:04 GMT

May be this:

If(Sum({$<DYear = {$(#vYear1)}>} Weight) > 450000, Sum({$<DYear = {$(#vYear1)}>} Weight))

Re: Set Analysis Filter

tresB — Tue, 09 Feb 2016 09:57:50 GMT

sum({$<DYear = {$(#vYear1)} , Weight={'>450000'}>} Weight)

Re: Set Analysis Filter

Anonymous — Tue, 09 Feb 2016 09:59:32 GMT

try if sum should be greater than 450000

if (sum({$<DYear = {$(#vYear1)}>} Weight) >450000, sum({$<DYear = {$(#vYear1)}>} Weight))

or if every weight should be more than 450000

sum({$<DYear = {$(#vYear1)},Weight={'>=450000'}>} Weight)