Expression work in QS but not work in QV

[paulyeo11]

Hi All

I have below expression work fine in QS :-

Aggr(

Rangesum( Above(

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales/1000)

,0,rowno()))

,year,(month,(NUMERIC,ASCENDING)))

When i use the above same expression to QV , it does not work , When i remove the Aggr(

Rangesum( Above( and it work fine ( ref to chart 1 ) :-

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales/1000)

May i know why ?

Paul

[Gabriel]

Hi,

You need another aggregation before AGGR

Sum(

Aggr(

Rangesum( Above(

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales/1000)

,0,rowno()))

,year,(month,(NUMERIC,ASCENDING))))

[paulyeo11]

Hi Gabriel

Thank you for sharing.

I try but it does not work .

Paul

[sunny_talwar · Accepted solution]

Are you using QV12? If not then the new sorting syntax won't work. Look here: The sortable Aggr function is finally here!‌

Aggr(

Rangesum( Above(

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales/1000)

,0,rowno()))

,year,(month,(NUMERIC,ASCENDING)))

[paulyeo11]

Hi Sunny

I read the link you posted to me , if i am correct , they post is mentioned that new feature is support QS and ver 12.

Since now i am still using ver 9 , so your posted expression with the red high lighted word on sort month , i have tested it is not working in ver 9 , but work in QS.

So can i said that ver 9 i am unable make it work , and i need to look for alternative ?

Paul

[sunny_talwar]

‌yup... That's exactly what it means. You need to update  

[paulyeo11]

Hi Sunny

it is okay , since presentation of chart , i can using QS.

Paul