topic Re: Showing max date as per month in QlikView

Showing max date as per month

deepakqlikview_123 — Thu, 10 Sep 2015 06:35:11 GMT

I have 2 days for each month that is last and second last i need to show last day for each date for respective month.

Please suggest

Thu, 10 Sep 2015 06:44:45 GMT

Hi can you send your exel sheet.

amit_saini — Thu, 10 Sep 2015 06:47:14 GMT

Deepak,

Use:

Thanks,
AS

Thu, 10 Sep 2015 06:52:53 GMT

Hi amit,

Deepak wants the last date.

amit_saini — Thu, 10 Sep 2015 06:55:13 GMT

Here it is:

Thanks,.
AS

deepakqlikview_123 — Wed, 23 Sep 2015 06:22:37 GMT

Hi All,

I need to show month end data MMM YYYY format can you please suggest how shall i go ahead.

Thanks

amit_saini — Wed, 23 Sep 2015 07:05:32 GMT

Deepak,

Either define this format at the back-end or from below:

Thanks,

PrashantSangle — Wed, 23 Sep 2015 07:12:00 GMT

Hi,

You can use MonthName()

date(fieldNAme,'MMM YYYY')

do as suggested by amit saini.

Regards