Solved: Showing max date as per month - Qlik Community

deepakqlikview_123 · ‎2015-09-10

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

PrashantSangle · ‎2015-09-23

Hi,

You can use MonthName()

or

date(fieldNAme,'MMM YYYY')

or

do as suggested by amit saini.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

Report Inappropriate Content · ‎2015-09-10

Hi can you send your exel sheet.

amit_saini · ‎2015-09-10

Deepak,

Use:

Thanks,
AS

Report Inappropriate Content · ‎2015-09-10

Hi amit,

Deepak wants the last date.

amit_saini · ‎2015-09-10

Here it is:

Thanks,.
AS

deepakqlikview_123 · ‎2015-09-23

Hi All,

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

Thanks

amit_saini · ‎2015-09-23

Deepak,

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

Thanks,

AS

PrashantSangle · ‎2015-09-23

Hi,

You can use MonthName()

or

date(fieldNAme,'MMM YYYY')

or

do as suggested by amit saini.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Showing max date as per month

QlikView App Dev