Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression :-
Sum(
{<Year={'>$(=year(today())-2)'}>}
sales/1000)
Since As in QS , i cannot find Accumulate Tick feature. For work around I like to make use of add RangeSum into above expression ? In order to create sales by accumulation without activate Accumulation Tick Box.
Enclosed my QV Sample Doc
Paul
Try as expression:
Aggr(
Rangesum( Above(
Sum(
{<Year={'>$(=year(today())-2)'}>}
sales/1000)
,0,rowno()))
,year,(month,(NUMERIC,ASCENDING)))
Try as expression:
Aggr(
Rangesum( Above(
Sum(
{<Year={'>$(=year(today())-2)'}>}
sales/1000)
,0,rowno()))
,year,(month,(NUMERIC,ASCENDING)))
Hi Swuehl
Many Thank it work fine in QS.
May i know why it does not display any line in QV ?
Paul
Are you using a QlikView version pre 12?
Have a look at
The sortable Aggr function is finally here!
for the changed syntax in QV 12 / QS 2.2.
If you need a solution for QV 11, you need to get your month field values load order in correct chronological order.
See the blog post and the referenced posts therein on how to do this.
Hi Swuehl
I am using ver 9 . By the way i seek help on below , similar like above :-
QS How to add accumulated line ?
I have apply what you share with me it unable to work in above expression. Hope you can help me.
Paul
Hi Swuehl
Thank you sharing . I read the blog post from the link you share , I think this related to Mr sunny try to help me solve and encounter the month not sort.
Paul
Sent from my iPhone