topic Variable greater than or less than variable in QlikView

Variable greater than or less than variable

nrwlafhus — Wed, 23 Sep 2020 02:54:50 GMT

I have a pivot table with a single expression. The requirement is to allow the user to filter the data in the pivot table based on two variables.

Variable 1: will be less than or greater than ( > or <)

Variable2: some integer

I would like to be able to have the user select < or > and enter a value and have the pivot table only show lines that fall within the variable range.

My current expression doesn't respond at all. =if(sum( Planned) - sum( Actual) & $(Variable1) & $(Variable2),
sum(Planned) - sum(Actual),null())

Any guidance would be appreciated.

Re: Variable greater than or less than variable

Vegar — Wed, 23 Sep 2020 04:05:46 GMT

Try removing the & signs like this :

=if(sum(Planned) - sum( Actual) $(Variable1) $(Variable2),sum(Planned) - sum(Actual),null())

Re: Variable greater than or less than variable

nrwlafhus — Wed, 30 Sep 2020 18:41:58 GMT

That worked! Thanks. How come when I use that expression the syntax checker doesn't accept it but it still works?