Filter variable in set analysis

Nighthawk — Wed, 14 Nov 2018 14:19:10 GMT

If i have a variable called vFoo. Can we filter this variable directly in set analysis?

Something like:

Sum({$<$(vFoo) = {"<10"}>}Sales)

Re: Filter variable in set analysis

Vegar — Wed, 14 Nov 2018 14:28:45 GMT

No, but an variable has single value therefore you could use an if statement.

IF($(vFoo) = <10, Sum(Sales),0)

Re: Filter variable in set analysis

petter — Wed, 14 Nov 2018 14:42:55 GMT

You can do this - but it is important that the vFoo will evaluate to something that is relevant and contains a field:

Sum( { <UniqueRowId={"=($(vFoo))<10"}> } Sales)

So the expression =$(vFoo)<10 should evaluate to a boolean result that determines which rows that would be included in the sum. If vFoo evaluates to a constant then the sum would be zero or if not the sum of all rows.

The field on the left hand side does not necessarily need to be a UniqueRowId but I find it easier to understand it and get it to work by having that as the field. If you have a non-unique row id as field means that the expression on the right hand side MUST have aggregation functions just like you would use in a "group by" in a SQL statement or LOAD statement.

topic Re: Filter variable in set analysis in QlikView

Filter variable in set analysis

Re: Filter variable in set analysis

Re: Filter variable in set analysis