Qlik expression editor - Variables

[#1]

Hello experts!

I have a problem with the expression editor of some charts. The code is the following:

Count ({<Field1={'>=$(VAR1)'}>} {<Field2={'$(VAR2)'}>}  Measure)

The problem is that the chart changes depending ONLY on the changes of the second vaiable mentioned in the script (here, VAR2). If i switch the variables in the expression, it changes again with the second one (in this case VAR1). Therefore there should be an error in the code, I want it changing depending on the 2 variables.

Could anyone help me?

Thank you very much!

[rahulpawarb]

Hello Andrea,

Trust that you are doing well!

Please refer given sample expression:

Count ({<Field1={">=$(VAR1)"}, Field2={"=$(VAR2)"}>}  Measure)

Hope this will be helpful.

Regards!

Rahul

[jonathandienst]

Your syntax for combining two conditions is incorrect - you can only have a one set filter in an expression. But the set filter can be as complex as required:

Count({<Field1 = {">=$(VAR1)"}, Field2 = {"$(VAR2)"}>} Measure) 

It would be helpful to explain how VAR1 and VAR2 are defined, as this might affect the correct syntax.