Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Set expression how to modify to > then 2017 ?

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Set expression how to modify to > then 2017 ?

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.

2 Replies
MVP
MVP

Re: Set expression how to modify to > then 2017 ?

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
Valued Contributor II

Re: Set expression how to modify to > then 2017 ?

Hi Jona

Thank you very much.

it work

Paul

Community Browser