topic Re: Date formatting issues. in Qlik NPrinting

Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:23:55 GMT

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 .

Re: Date formatting issues.

Anil_Babu_Samineni — Wed, 15 Feb 2017 17:26:42 GMT

May be using this

Date([Service Sttributes],'MMMYYYY') as [Service Sttributes]

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:27:25 GMT

either you set the cell format of your excel template or activate "keep source format".

Have a look here, section: Add Object as Table and Change "Keep Source Formats"

How to Create a Pivot Table from Excel Table Columns

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:28:51 GMT

I am able to get in qlikview . but not in n printing.

The expresssion above i have used is working fine.

Re: Date formatting issues.

kakaderanjit53 — Wed, 15 Feb 2017 17:29:23 GMT

Hi Vamasi Krishnna,

just check the checkbox under the property option of table i.e. on left hand side in Nprinting

"keep source format" must be selected

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:36:12 GMT

Hi ,

sorry i cant find it .

Can you send a pic pls.

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:41:14 GMT

, you will find it in the report editor...

Have a look here, section: Add Object as Table and Change "Keep Source Formats"

How to Create a Pivot Table from Excel Table Columns

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:48:17 GMT

I cant see many properties.Why??

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:50:00 GMT

Sorry my mistake .I should add it to the table not to the level. Let me try.

Re: Date formatting issues.

Stephen_Jasionowski — Wed, 15 Feb 2017 17:51:04 GMT

You need to add the object to the Tables instead of the level. Right click on Tables and add CH08.

Re: Date formatting issues.

kakaderanjit53 — Wed, 15 Feb 2017 17:52:20 GMT

hi,

yes, level is used for duration

for e.g. year .

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 17:53:39 GMT

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

Re: Date formatting issues.

kakaderanjit53 — Wed, 15 Feb 2017 17:59:43 GMT

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.

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 18:07:33 GMT

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

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 18:09:12 GMT

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

Re: Date formatting issues.

Daniel_Jenkins — Wed, 15 Feb 2017 21:30:19 GMT

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.

Re: Date formatting issues.

Anonymous — Wed, 15 Feb 2017 22:47:10 GMT

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

Re: Date formatting issues.

Anonymous — Thu, 16 Feb 2017 11:07:32 GMT

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.

Re: Date formatting issues.

Daniel_Jenkins — Fri, 17 Feb 2017 00:28:35 GMT

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