topic Re: Calculated columns with nested values in Qlik NPrinting

Calculated columns with nested values

curiousfellow — Wed, 19 Jul 2023 11:59:28 GMT

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>

Re: Calculated columns with nested values

Lech_Miszkiewicz — Wed, 19 Jul 2023 13:13:35 GMT

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.htm

there you have all instructions required.

cheers

Re: Calculated columns with nested values

Frank_S — Wed, 19 Jul 2023 19:55:17 GMT

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...

Re: Calculated columns with nested values

curiousfellow — Thu, 20 Jul 2023 07:31:52 GMT

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.

Re: Calculated columns with nested values

curiousfellow — Thu, 20 Jul 2023 07:32:24 GMT

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

Re: Calculated columns with nested values

Frank_S — Thu, 20 Jul 2023 14:25:57 GMT

No worries.