topic Re: Changing date to Month Year?? in QlikView

Changing date to Month Year??

Wed, 26 Apr 2017 19:07:43 GMT

How do I change a date from MM/DD/YYYY and MMM-YY to MMM YYYY?

How would I then restrict the chart to show only the most recent month in the dimensions?

TIA

vishsaggi — Wed, 26 Apr 2017 19:12:07 GMT

In your script try like:

Date(Date#(YourdateField, 'MM/DD/YYYY'), 'MMM YYYY') AS DateFieldName

Date(Date#(YourdateField, 'MMM-YY'), 'MMM YYYY') AS DateFieldName

Dim:

//Reference taken from here check here?

= Aggr(Max(DateFieldName), DateFieldName)

Wed, 26 Apr 2017 19:23:03 GMT

This did not work, but I figured it out based on this.

How do I show only the previous months data in the dimensions of a bar chart?

Wed, 26 Apr 2017 19:31:02 GMT

for the dimension, that is showing for multiple months. I am trying to only show one month of data- being the last month

vishsaggi — Wed, 26 Apr 2017 19:37:41 GMT

Can you share your sample app for a quick look at it?