Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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> |
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...
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:
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
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...
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.
Thanks,
What I overlooked is that I had to add a level for the dimension too.
No worries.