Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need merge cells feature (similar to excel) to merge cells with same data in any column.
I cannot use Pivot table to use its grouping capability for merging, because, I need this table to be connected to nprinting and get an editable output, whereas Pivot is read by nprinting as image, another issue with pivot is all grouped and merged cells need to be on left side, whereas my requirement is to have this merge cells feature on any column.
Attached is input data and output expected.
Is it possible to create a extension for this requirement and yet be read by nprinting as editable data?
I am sure you have already read this but i am putting below link just for reference if others would like to know. It lists requirements your extension needs to meet to work properly in NPrinting - (note the requirement for the object to be able to work as a table).
I quess you would have to test it by yourself if creating an extension you want is possible and if it will cooperate with NPrinting as you want it. That however will have to be supported by yourself.
I will not comment on it as i cannot test it by myself. I am also against using unsupported extensions just because they create more problems than benefits from my experience.
I am not sure if this would fit your requirements but,
I would use Qlik Sense Pivot table and NPrinting as it exports data as per your request retaining grouping. The only problem is to have different column order which you could change using macro in xls.
If you give me exact requirements i may be able to do small POC,
btw - it is not true that pivot table are only exported as images. That is an old statement. If you keep your NPrinting and Qlik Sense versions up to date then you will be able to export data as well.
cheers
Lech
Hi Lech,
Thank you so much for the help.
I do not yet have access to Nprinting, which I would get in couple of days, so, I will check it with Pivot solution.
Version would be November 18 Version 18.39.6.0, I hope this supports Pivot with data and not as image.
Requirement is simple as shown in figure attached in post and just compare with its previous data and highlight those records using some coloring and report generated in ppt (with editable data) and pdf.
So, if Pivot and Nprinting Nov1.7 version gets an editable output in ppt, then I can manage with pivot
Thanks.
Narayana
Oh well, there is one big issue - you want this in Power Point which you did not mention initially and which changes whole conversation.
So I could easily see it working as editable Excel report with Macro, but I do not see it working with PPT (at least not with my skills. Regarding your original question re extension - I do not think this will be possible and definitely it will not be supported by Qlik
cheers
Lech
I am sure you have already read this but i am putting below link just for reference if others would like to know. It lists requirements your extension needs to meet to work properly in NPrinting - (note the requirement for the object to be able to work as a table).
I quess you would have to test it by yourself if creating an extension you want is possible and if it will cooperate with NPrinting as you want it. That however will have to be supported by yourself.
I will not comment on it as i cannot test it by myself. I am also against using unsupported extensions just because they create more problems than benefits from my experience.