How to add a column (field) in a Table that is an expression that requires context of multiple Raw

[#1]

Hello the community,

I'm quite new in qlik and I would appreciate your experience

I have a table with 2 columns :

TimeStamp                     Usage-HH

M/D/YYYY hh:mm:ss       Number

I Create this Table thanks to a LOAD * of a external excel file that give the Usage for each Hour

I would like to create a table with extra columns to give context ie create new fields that results of expression from different Rows

The new columns I want to create

• Usage-Average-Day    => give for each hour the context of the average usage during this day
• Usage-Max-Day           => give for each hour the context of the average usage during this day
• Usage-Average-Week  => give for each hour the context of the average usage during this week
• Usage-Max-Week           => give for each hour the context of the max usage during this week

I will after use directly these new fields to create Graph.

I want to avoid to create expression directly in the Graphs Dimension.

Thanks for your support

[Anonymous]

Hi

you can with RANGEavg(ABOVE(SUM{1}(Usage-HH),0,RowNo()))     in   expression of a graph...

[#3]

Hello,

In fact I want to avoid to add expression in graph.

I want to make complex expression in the script.

How can I use RANGEavg(ABOVE(SUM{1}(Usage-HH),0,RowNo())) to create Usage-Average-Day new field

I want to build new tables  within the scripts and then display the new fields created with basic expression of a graph.

Regards