Calculated columns with nested values

[curiousfellow]

In my report I have two levels , then in a column (column1) a dimension value and in the next column a calculation for example column(1) * cell N$3

When I run this report the calculation is only made for the first dimension values of a level. Next column cells are empty.
Is it possible what I want ?
Besides that the reference to cell n$3 changes in the report to n$1.

It is not possible to use a table as a source for my report.

level1
	level2				what i want	what I get
		dimension1		10	100	100
		dimension2		20	200
		dimension3		30	300
	</level2>
</level1>

[Lech_Miszkiewicz]

Hi @curiousfellow  

Yes it is possible.

Which tutorial or training did you follow when building your template? 

If you would have followed official documentation there you see that in order to have excel formulas you either:

• need to use named tables
• or you need to use levels for every part of your table (including dimension1)

good luck.

help site: https://help.qlik.com

from there you go to NPrinting section and follow the left panel menu to: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ExcelReports/Make-Calculated-Column....

there you have all instructions required.

cheers

[Frank_S · Accepted solution]

Hi @curiousfellow 

It's always helpful to mention which version of QlikView or Qlik Sense that you are running so we can use that version information to try build a solution.

So with out that, will assume QlikView and share the QVW and report with you attached.

Here you can see how to construct it and the results.

D4 is an excel sum expression of C4 and B4.

Kind regards...

[curiousfellow]

Hello,

Several years ago I followed a course given by a reseller. I think it was the 2016 version then.
Since then I created several reports (scheduled and not scheduled). Some of them are running daily.
I have used levels in various reports but never with calculated columns.

I found the help text you are referring to before asking on this forum.

What I overlooked is that I had to add a level for the dimension too.

[curiousfellow]

Thanks,
What I overlooked is that I had to add a level for the dimension too.

[Frank_S]

No worries.