I have a Pivot table in QlikView and want to export same in N-Printing.
How do I go about it, because when exporting Pivot Table from QlikView to N-Printing it's getting converted into Straight Table.
I want the below exact table in N-Printing Excel Report Distribution.
Can anyone pls help me.
I also went back to your original question. So how about using straight table all the way with some hacks (like changing font color to white in order to hide duplicated values on dimensions.
Samle attached !
1. Firstly You can take it as Image like same you designed in qlik.
2.Design pivot table using excel sheet option.
-> Firstly create straight table in qlikview/ Qliksense
-> Then go to nprinting designer
-> Add table into your excel designer sheet,
-> Seelect table range Menu Insert-> Pivot table-> Draw table as wish you.
This was discussed many times on community.. Below are examples of different solutions. Pick and choose which one suits you best.
On the other hand i am surprised what you are saying that pivot table gets converted. I tested it and it does not...check here:Nprint Pivot table formatting issue
I already checked with the mention link. When a Pivot Table is placed in N-Printing & once you preview it, then it doesn't has the same Grouping which is seen in QlikView. see below it give the output has
And I am not able to create Pivot using this link How to Create a Pivot Table Report with QlikView Data because my expression has Set Analysis used. So simply I can't put SUM(Sales) instead I have some conditions in it.
you can still do this (even with the set analysis)
I followed the same step, I am getting the grouping but my variables are not working.
Say for e.g. My headings of the table is vMaxMonth then it is not coming as Jul-2018, instead its giving vMaxMonth only.
I am not able to do any formatting in the created Pivot Table. Tried many ways and still trying on it.
it is because you are not evaluating variable
depending where you are putting it you need to prefix it with = sign
Thanks for your prompt reply.
The same variable when I insert in second sheet, then I can see the value for it. But in the sheet where the Pivot Table is there it doesn't appear.
The same way when I insert the variable (<vDisb1> in the next sheet I am getting it.
Where vDisb1 is =='Q'&vMaxQtr &' Target per Month' . (heading for my table)
i dont get it?
is this result in nprinting Or in Qlik?
my question is how is your column label looking like in Qlik table?
you might need to use $ sign expansion to get this right, but it all depends how you evaluate your variables.
To simplify provide us with screenahots of: