Set expression

[FrankGrimm]

Hello together,

i have an expression

=count({$<[RAM (MB)]=7999>} System)

It works perfekt.

But when i try to count the Systems which have less then 7999 RAM (MB) i get an error.

=count({$<[RAM (MB)]<7999>} System)

Error in set modifier. 

How to use < or > or <> or >= or <= in a set expression?

Thank you

[Or · Accepted solution]

count({$<[RAM (MB)]= {"<7999"} >} System)

I'd recommend reading: https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

since this example (as well as several other common ones) are covered there and it can be used as a reference.

[RafaelBarrios · Accepted solution]

Hi @FrankGrimm 

actually =count({$<[RAM (MB)]=7999>} System) should not work

anything you want to evaluate inside the [RAM (MB)] field has to go inside "{ }"

for instance

equal to 7999 would be =count({$<[RAM (MB)]={7999} >} System) and as 7999 is just a number, can go without single or double quotes

if it was text you would need quotes, for example =count({$<[SERVER NAME]={'Server1'} >} System)

now, since you want to perform an evaluation inside the field < or > or <> or >= or <= you will need the double quotes =count({$<[RAM (MB)]={"<=7999"} >} System)

Hope you have it more clear.

Best,

[FrankGrimm]

Thanks  lot!

[FrankGrimm]

Thanks you for your help!

[RafaelBarrios]

Hi @FrankGrimm 

remember to please  click on "Accept as Solution" to @Or or my post if this resolves your query.

Best,