Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Expression help

Dear all,

I have the below expression and would really appreciate some help to add when the trade_dt_weekname = 2020/31

Sum(Aggr(
Avg(Aggr(
abs_pos_vol
, our_reference, abs_pos_vol))
, our_reference))

Regards,
Daniel

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

may be below

Sum({<trade_dt_weekname = {'2020/31'}>}Aggr(Avg({<trade_dt_weekname = {'2020/31'}>}Aggr(sum({<trade_dt_weekname = {'2020/31'}>}abs_pos_vol), our_reference, abs_pos_vol)), our_reference))

View solution in original post

1 Reply
Highlighted
MVP
MVP

may be below

Sum({<trade_dt_weekname = {'2020/31'}>}Aggr(Avg({<trade_dt_weekname = {'2020/31'}>}Aggr(sum({<trade_dt_weekname = {'2020/31'}>}abs_pos_vol), our_reference, abs_pos_vol)), our_reference))

View solution in original post