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 .