topic Re: Order the month in Qlik NPrinting

Order the month

Chanty4u — Mon, 24 Apr 2017 07:24:30 GMT

Hi all,

Andy Weir

i am unable to sort the month field in NPrinting 17.2.3

i have excel template field like month like below i want to sort by jan,feb,mar,aprl,.....

but it is not getting .

can anyone help on this?

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 07:39:07 GMT

Do your sorting in your qlik sense/view chart not in nprinting.

Either with a month number value in your master calendar or a value list.

Regard

Andy

Re: Order the month

Anil_Babu_Samineni — Mon, 24 Apr 2017 07:41:34 GMT

try this from Development environment only. Tricky to do in N-Printing.

Do your sorting in your Qlik Sense/Qlik View chart not in nprinting.

Re: Order the month

Chanty4u — Mon, 24 Apr 2017 07:51:41 GMT

No andy,

In Qlik its in sorting order only means Feb2017,jan2017,dec2016,nov2016 .in desc order it is there in qliksense

but my out put excel template is coming like above.

i dont have ant value list for the month field.

in script

MonthName(MakeDate(if(PERIOD>9,FISCAL_YEAR+1,FISCAL_YEAR),if(PERIOD>9,PERIOD-9,PERIOD+3),'1')) as [Month Name]

Re: Order the month

avinashelite — Mon, 24 Apr 2017 07:59:50 GMT

Are you recreating the chart in NPriting ?

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 08:06:12 GMT

I notice there you have a piviot table in sense.

Last time i tried it the piviot table wouldnt convert to a table could only bring in as an imagine into nprinting. Is that not the case now? Im on 17.3.

If you are bringing it in as an imagine then sorting shouldnt be an issue. If you are importing a table try bering in just the table object and keep its formating no customising of the individual columns.

Regards

Andy

Re: Order the month

Chanty4u — Mon, 24 Apr 2017 09:08:01 GMT

Actually,

i created empty excel temple with pivots with data first then after i deleted data and done the refresh all,

then it will be empty template with layout pivot . when we drag objects in designer the out put coming like that.

Re: Order the month

Chanty4u — Mon, 24 Apr 2017 09:09:58 GMT

yes andy its table not image,

and there is no customization of columns'

Re: Order the month

avinashelite — Mon, 24 Apr 2017 09:11:44 GMT

Check the options in Excels for the sorting ..its nothing to with the NPrinting

Sort data in a PivotTable or PivotChart - Excel

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 09:22:35 GMT

I mimic but do not use a piviot table in my (Nprinting dedicated) Sense app but using a straight table then brought it into nprinting as a straight table. It took more effort to setup but allowed me to bypassed the sorting and layout issues I just brought it in as is.

Re: Order the month

Chanty4u — Mon, 24 Apr 2017 09:54:29 GMT

but i have lot of sheets in excel so i cant do it for all pivots into stright

is there any other alternative?

Re: Order the month

Chanty4u — Mon, 24 Apr 2017 09:55:36 GMT

i have done all the sorting options in excel earlier only. still i didnt get it avi.

Re: Order the month

avinashelite — Mon, 24 Apr 2017 10:12:44 GMT

Then I feel we are missing some where ...share the excel file

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 11:13:18 GMT

Although I wouldnt recomend this as you will need to keep updating your custom list.

Creat a custom list and apply it to your excel sheets.

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 11:14:04 GMT

Heres the work sheet.

Re: Order the month

Chanty4u — Mon, 24 Apr 2017 11:41:31 GMT

thanks andy,

am using excel 2016 in that i didnt found custom list. how can i add ?

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 12:01:18 GMT

Select your list to sort and in the data sort section of excel you will have an option for custom sort. select that and then in the drop down at the end you will have the option of setting a custom list.

Add your entries in and then apply them like i've done in my example. Like I say this is not a great way to do this as there is a maintenance overhead but will meet your requirement.

Re: Order the month

Chanty4u — Mon, 24 Apr 2017 12:07:30 GMT

in my excel it is not there. could you do it in my abve attached excel?

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 12:15:45 GMT

In the piviot table its in a slightly different location under more sorting options.

Re: Order the month

ogster1974 — Mon, 24 Apr 2017 12:16:52 GMT

Your sorted excel in both Piviot and table.