Set expression how to modify to > then 2017 ?

[paulyeo11]

Hi All

Below expression is working well :-

Sum({<year={2017},sub_seg={"01"}>} sales)

I like to modify the expression to for more then 2017 instead of equal to 2017 and I have try below :-

Sum({<year>{2017},sub_seg={"01"}>} sales)

Sum({<year{>2017},sub_seg={"01"}>} sales)

Not working

Paul Yeo

[jonathandienst · Accepted solution]

Like this

Sum({<year = {">2017"}, sub_seg={'01'}>} sales)

Quoting rules

double quotes " - search expression, like >2017

single quotes ' - literal text, like '01'

These are rules were previously disregarded, but are now being enforced in new models created using the most recent versions of QS/QV.

[paulyeo11]

Hi Jona

Thank you very much.

it work

Paul