Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there any how-to tutorial on how to perform changes in the connected app and fully work it into the Nprinting report?
I know, I have to reload metadata, but I don't find much help on how to proceed afterwards.
In the current case:
I have some complicated powerpoint Charts, I wouldn't want to completely redo. After the changes, the powerpoint output only displays the formula itself, but not the values.
Thanks in advance for any help!
Hi @Moritz,
There are fev confusing things:
Your usecase of pages:
regarding pages read this: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/PowerPointReports/Page-Features.htm
It clearly says: "The page feature causes a separate slide to be created in PowerPoint for each field value." It meas you can only use fields from your data model and you cannot use calculated dimensions as a <page> tag. You can only use:
Also with your expression - what are you trying to achieve with it? Waht is the purpose of If(statement). Note that in your expression tag "<" and ">" characters are replcaed with "_" so I was not sure how exactly the expression looks like. It seems like you are not wanting 0 values to be shown, but that could be easily achieved with number formatting and you wouldn't need If statement at all.
You also said "I had trouble with 3) update object <tag> string in the template." What do you mean by that? You couldn't change the text in your Power point to reflect what the new formula looks like? or did you mean something else?
Cheers
Lech
Hi @Moritz
1. It is not master dimensions but master measures which i was talking about
2. regarding removing 0 values it is very simple - just disable keep source format and use custom format. You dont need expressions like yours to achieve what you need.
#,##0;-#,##0; ;
Which represents
"positive value format " ; "negative value format" ; "zero value format" ; "text value format"
I dont know what regional settings you have in your environment so double check that the number format meets your region settings.
(excel topic but the same principles) https://www.ablebits.com/office-addins-blog/custom-excel-number-format/
Keep source formats and format in Qlik help explained: https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/ReportsDevelopment/Designer-pro...
hope this helps
cheers
Hi @Moritz
It is very simple and it goes down to proper preperation and Qlik Sense app design.
If you were using variables as expressions or master items those would not change and string withing the <nprinting tag> would remain the same which would save you ton of work and reduce the maintanance down to changing expression in variable or master item - simple as that - for example:
Example below shows you 3 columns doing the same - one is having naked expression, second has the same expression in master measure and third has the same expression in variable. When brought in to NPrinting they look like this:
So change in expression (1) which has naked formula requires metadata update and update of object in designer and template as string with expression will change and will no longer work in template:
Expressions 2 & 3 will have the same strig despite underlying expression being updated in Qlik Sense which will save you a lot of work on NPrinting side, debugging and testing in the future.
Since you are making this change now I suggest you convert your expressions either to master items or variables and use those going forward so any future changes will save you time when done.
Now you know why prep is so important long term and what you need to do to avoid this again in the future.
cheers.
Hi,
thanks so much already for your help @Ray_Strother @Lech_Miszkiewicz !
Confirming that I reloaded meta data and updated the objects. I had trouble with
3) update object <tag> string in the template.
So far I didn't use Master Items, as none of them is showing up in the fieldlist, if I want to use them within the "page" object to cycle through:
Can I nevertheless use Master Items within the set expressions?
To give you an example of an expression I have to use - see below - I work with a variable, which itself is hard-coded. (vPreviousYear)
<if(Sum({_ [Invoiced Date Fiscal.Fiscal Year Value]={'$(vPreviousYear)'}, [Sales Invoice Fact.Unit Selling Price]={"_0"}, [Invoiced Date Fiscal.Months From Current Fiscal Month] -= {'0'}_} [Sales Invoice Fact.Net Invoiced Quantity Reporting]) _ 0,Sum({_ [Invoiced Date Fiscal.Fiscal Year Value]={'$(vPreviousYear)'}, [Sales Invoice Fact.Unit Selling Price]={"_0"}, [Invoiced Date Fiscal.Months From Current Fiscal Month] -= {'0'}_} [Sales Invoice Fact.Net Invoiced Quantity Reporting]),'')_2>
Thanks,
Moritz
Hi @Moritz,
There are fev confusing things:
Your usecase of pages:
regarding pages read this: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/PowerPointReports/Page-Features.htm
It clearly says: "The page feature causes a separate slide to be created in PowerPoint for each field value." It meas you can only use fields from your data model and you cannot use calculated dimensions as a <page> tag. You can only use:
Also with your expression - what are you trying to achieve with it? Waht is the purpose of If(statement). Note that in your expression tag "<" and ">" characters are replcaed with "_" so I was not sure how exactly the expression looks like. It seems like you are not wanting 0 values to be shown, but that could be easily achieved with number formatting and you wouldn't need If statement at all.
You also said "I had trouble with 3) update object <tag> string in the template." What do you mean by that? You couldn't change the text in your Power point to reflect what the new formula looks like? or did you mean something else?
Cheers
Lech
thanks again for your great help, I will test the master dimension approach then, for the measures.
For the is statement: You're right, this serves to remove the 0. Unfortunately, I didn't find a better solution to not display 0s within a powerpoint chart data table, as the formating options are very limited in this.
Concerning "I had trouble with 3) update object <tag> string in the template.": Guess this was just an error on my side, it now works fine, when I drag 'n drop the field I updated.
Thanks again!!
Hi @Moritz
1. It is not master dimensions but master measures which i was talking about
2. regarding removing 0 values it is very simple - just disable keep source format and use custom format. You dont need expressions like yours to achieve what you need.
#,##0;-#,##0; ;
Which represents
"positive value format " ; "negative value format" ; "zero value format" ; "text value format"
I dont know what regional settings you have in your environment so double check that the number format meets your region settings.
(excel topic but the same principles) https://www.ablebits.com/office-addins-blog/custom-excel-number-format/
Keep source formats and format in Qlik help explained: https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/ReportsDevelopment/Designer-pro...
hope this helps
cheers
@Lech_Miszkiewicz Why make it simple when it can be complicated?
Thanks so much again, this works great now!
The only thing which doesn't work so far is the conditional format to show M an K in case of big numbers:
[>=1000000] $# ##0.0,, "M" ;[<1000000] $# ##0.0, "K"
Please allow me a follow-up question as this seems inviting to use. Do you see this working on your end?
Thanks,
Moritz