Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amit_saini
Honored Contributor III

How to show only vaule for the last week of the month

Hi Folks,

How to show value only  for the last week of the month

Thanks,

AS

3 Replies
jpenuliar
Valued Contributor III

Re: How to show only vaule for the last week of the month

try:

=Weekname(MonthEnd(today()))

Re: How to show only vaule for the last week of the month

Could you share your data/layout?

balkumarchandel
Valued Contributor II

Re: How to show only vaule for the last week of the month

Hi

if it is some calculation for last week of every month

then you can use

if(week=Week(MonthEnd(Datecol)),sum(col1))

PS : week =  week no column column in your datamodel

Community Browser