Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jvk_sharma
Creator III
Creator III

Date formatting issues.

Hi ,

I have a straight table in qlikview and I am generating the reports in Nprinting as pivot table (converting straight table to pivot by using excel in nprinting)as it is not possible to incorporate the pivot table from qlikview to nprinting directly.

Now I am having the formatting issues for the date.

i have tried the other possible formats to change but i am unable to do that.

Any help is appreicated.

This is the code i am using in qlikview .

Date(MonthStart("recorded_at"), 'MMM/YYYY') as "Month/Year"

you can see in the figure 1 .it has formatted accordingly.

But in the figure 2 i am unable to get those even after formatting the cells .

services.pngservices.png

18 Replies
kakaderanjit53
Creator III
Creator III

hi,

yes, level is used for duration

for e.g. year .

Anonymous
Not applicable

I never used levels, did you try to format the cells of your excel template?:

kakaderanjit53
Creator III
Creator III

Hi ,

No I cant send the picture ,right now due to out of office ,There is no access for Nprinting,

just qlik On the table hierarchy level insted of Object Title of Code then you will be get the properties of every segment.

jvk_sharma
Creator III
Creator III
Author

I have followed every step of that docuservices.pngment . but still getting those date format issues.

jvk_sharma
Creator III
Creator III
Author

I have selected that box but it is still showing the date issues in the n prservices.pnginting.

Daniel_Jenkins
Support
Support

Hi Vamsi,

As mentioned in the article you linked to you should not check Keep source formats. Use Excel formatting instead.

Straight table in QlikView:

Follow How to Create a Pivot Table from Excel Table Columns

Then format in Excel:

Output:

HTH - Daniel.

View solution in original post

jvk_sharma
Creator III
Creator III
Author

Thanks Daniel. I have left the office for the day. I will tomorrow.thanks for your help.cheers

jvk_sharma
Creator III
Creator III
Author

Thanks Daniel.

It has worked now and showing the dates in the required format.

Now i want to avoid these totals coming onto the excel sheet How to do this.

services.png

Daniel_Jenkins
Support
Support

Answered by Matus here: How to remove this !!!