topic Re: How to show previous month last day value in QlikView

How to show previous month last day value

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have tried the approach but not able to show only those values in current month

which are not purchased on the last working day of previous month

and rest of the value of current month also should got exclude

I have tried belwo expression also

=IF(DATE<>'$(vPrevMonthLast)' AND Pur_Cd='Purchase',Only({$<DATE={">=$(vFromDate)<=$(vToDate)"}>} ID))

but above expression is taking current month ID also which i do not want

vPrevMonthLast=Need to take last working day of previous month'

PFA

Regards,

Re: How to show previous month last day value

vishsaggi — Thu, 03 May 2018 16:20:29 GMT

Try like

= MonthEnd(AddMonths(YourDateField, -1))

Re: How to show previous month last day value

Chanty4u — Thu, 03 May 2018 16:22:59 GMT

what is the variable value?

use this in variable

monthend(Datefield, -1)

Re: How to show previous month last day value

Karim_Khan — Thu, 03 May 2018 16:25:56 GMT

I already have variable value

=MaxString({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE)

Re: How to show previous month last day value

Karim_Khan — Thu, 03 May 2018 16:26:04 GMT

=MaxString({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE)

Re: How to show previous month last day value

Chanty4u — Thu, 03 May 2018 16:29:33 GMT

what is the result you are getting for your variable?

Re: How to show previous month last day value

vishsaggi — Thu, 03 May 2018 16:59:28 GMT

Where in your variable you want this last day of the previous month?

Re: How to show previous month last day value

vishalarote — Fri, 04 May 2018 06:16:57 GMT

Try this hope so it will help you

vmindate=Date(min(TRADE_DATE))

vmaxdate=Monthend(Date(Max(TRADE_DATE)),-1)

Set Analysis :

=maxstring({<TRADE_DATE={">=$(vmindate)<=$(vmaxdate)"}>}DATE)

Re: How to show previous month last day value

sasiparupudi1 — Fri, 04 May 2018 10:39:28 GMT

Try

MonthEnd(Max({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE),-1)

Re: How to show previous month last day value

Karim_Khan — Fri, 04 May 2018 11:07:55 GMT

am able to find out the last workin day of previous month but the logic which m trying is not working

Re: How to show previous month last day value

Karim_Khan — Fri, 04 May 2018 11:08:07 GMT

am able to find out the last workin day of previous month but the logic which m trying is not working

Re: How to show previous month last day value

sasiparupudi1 — Fri, 04 May 2018 11:32:35 GMT

When you say logic is not working what exactly is the problem?

wht is the variable value vTradeFrom

Re: How to show previous month last day value

Karim_Khan — Fri, 04 May 2018 11:38:24 GMT

its is nothing jst startdate of my DATE filed

Re: How to show previous month last day value

vishsaggi — Fri, 04 May 2018 14:38:30 GMT

Can you share a sample you are working on? And also highlight the logic where you implementing this?