Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Set Analysis Filter

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


J

1 Solution

Accepted Solutions

Re: Set Analysis Filter

May be this:

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

3 Replies

Re: Set Analysis Filter

May be this:

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

MVP
MVP

Re: Set Analysis Filter

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

hrlinder
Honored Contributor

Re: Set Analysis Filter

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)

Community Browser