topic Re: Set expression how to modify to > then 2017 ? in QlikView

Set expression how to modify to > then 2017 ?

paulyeo11 — Tue, 27 Feb 2018 06:55:03 GMT

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 — Tue, 27 Feb 2018 06:57:06 GMT

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 — Tue, 27 Feb 2018 07:11:31 GMT

Hi Jona

Thank you very much.

it work

Paul