Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use of inter record functions in calculated dimention

Hi all,

I have a table like the one below. The columns are as follows:

1. date - startdate (i.e. days between start and measurement)

2. =aggr(rangesum(above(Avg(ErstattetTemperatur),0,rowno())),Dato) (This is the one giving me grief)

3. =avg(Sluttvekt) i.e average weight that day

4. =Avg(ErstattetTemperatur) i.e. average temperature that day

5. =RangeSum(ErstattetTemperatur,Above(TOTAL Column(3))) i.e. accumulated daydegrees (running sum of average temperature).

The first two columns are dimensions, and the three last ones are expressions.

My challange is to make a scatter plot of column 5 vs 3, where the division of points is based on column 1. The others are just there temporarily for the purpose of getting this correctly.

As I understand it, I need to make column 5 into a calculated dimension (which is what i tried in column 2). So my question is simply, how can I get the same values as I have in column 5 into a calculated dimension?

Any suggestions are highly appreciated!

Regards,

Ståle

growth.jpg

0 Replies