SET expression add filter COMPETITOR=wago

paulyeo11 — Sat, 02 Apr 2016 03:20:17 GMT

Hi All

I using button to select only 4 company :-

COMPETITOR

(WAGO|PRECICON|iTDS|TDS_G|INTERMECH)

I need to insert filter expression into below SET expression :-

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000

My approach :-

In the past i can insert filter less then current year.

money((Sum({<year = {"<=$(=Year(Today()))"}, $(ColumnDim51)={$(ColumnDim51)}>} Amount)/$(Columndim89)/1000), $(vMoneyFormatK))

So i assume expression as below :-

sum({$<year = {">=$(=max(year),4)"},COMPETITOR='WAGO'and'PRECICON', month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000

But not work.

Paul

Re: SET expression add filter COMPETITOR=wago

paulyeo11 — Sat, 02 Apr 2016 03:21:36 GMT

my QV Doc

topic SET expression add filter COMPETITOR=wago in App Development

SET expression add filter COMPETITOR=wago

Re: SET expression add filter COMPETITOR=wago