Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to make a report in Nprinting, version September 2017.
I put a calculated column, and I use a level. But when i want preview a report, then I see that a calculated column is not filled in all rows,
just a first row of all levels.
What can I do?
Thankssss,
Jasmina
Thanks for the screenshot. It seems a bug that appears when you insert an Excel table inside a level. As workaround you can use nested levels:
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
add one more row with dummy data along with <deleterow> and select the range the row also and preview
Hi,
If you are using levels in an Excel template you must insert the formula to calculate the new columns between the levels tags as in the picture:
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
I have already done that but doesn't work
Jasmina
Thanks for the screenshot. It seems a bug that appears when you insert an Excel table inside a level. As workaround you can use nested levels:
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Thank you very much. Now it is working.
But I have another question, maybe you can help me, or I will open an another topic.
Now I need sparkline column.
And the same thing is happening. Just in one row I get result.
Excel doesn't allow me to manipulate with $ in sparkline edit. 😕
Thank you
Jasmina
Yes, please open a single conversation for every question. Thanks
Hi,
This bug will be solved in next release June 2018.
Best regards,
Ruggero