topic Re: How to Display max(Year month) and current Time in QlikView

How to Display max(Year month) and current Time

Wed, 04 Mar 2015 18:48:02 GMT

Hi Friends,As new to QlikView as it may simple myself not aware of things like Date in QV can any one help on below thing:

Modified date having updated/modified time stamp need to display max(Modified Date) in Jan 2015(MMM YYYY)

Modified Date

201501

How can we achieve this in a text object?

2)If i have combination as below

Modified Date

201501

201409

2015Jan

201412

How can i show into Max(Modified Date)'as Jan 2015 MMM YYYY'

Re: How to Display max(Year month) and current Time

JonnyPoole — Wed, 04 Mar 2015 18:56:41 GMT

This should work. Date() is an output formatting function for display purposes. Date# reads/interprets incoming data helping qlik to interpret the incoming format. you can use them together in tons of ways:

1. Date( Max([Modified Date]) , 'MMM YYYY')

2. i think you may need to read the YYYYMM and YYYYMMM differently...

date( if( len([Modified Date]) = 7 , date#([Modified Date],'YYYYMMM') , date#( [Modified Date], 'YYYYMM') , 'YYYY MMM')

Re: How to Display max(Year month) and current Time

maxgro — Wed, 04 Mar 2015 19:09:32 GMT

date(max(if(IsNum([Modified Date]), Date#([Modified Date], 'YYYYMM'), Date#([Modified Date], 'YYYYMMM') )), 'MMM YYYY')

Re: How to Display max(Year month) and current Time

dickelsa — Wed, 04 Mar 2015 20:01:05 GMT

The best way ( I think) is to use purgechar to recognise the letters in the string.

purgechar(<fieldname>,'<symbols>')

so for instance you can check in the script:

date(if(IsNull(Purgechar([Modified Date],'0123456789 ')), Date#([Modified Date], 'YYYYMM'), Date#([Modified Date], 'YYYYMMM') ),'YYYYMMM') as [Modified Date]

So now, you have your dates are in the same format you can simply put:

Next, in the dashboard you can put simply date(max(Date#([Modified Date],'YYYYMMM'),'MMM YYYY')

Best regards,

Dick