topic Re: set expression in QlikView

set expression

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

Hi Experts,

How to write the expression for the year to last month end

for example now the current month is June if i click on year then i want from 01/01/2017 to may end.

How to writhe expression for that?

lironbaram — Fri, 09 Jun 2017 07:21:01 GMT

assuming you have a date field called DATE

it should be something like

sum({<DATE={'<=$(=date(floor(monthend(addmonths(today(),-1))))'}>}SALES)

Anil_Babu_Samineni — Fri, 09 Jun 2017 07:22:31 GMT

You can do with YearStart() and YearEnd() functions

prma7799 — Fri, 09 Jun 2017 07:33:18 GMT

Please check

=sum({$<[Date] = {"<=$(MonthEnd(AddMonths([Date],-1)))"} >}[Sales])

antoniotiman — Fri, 09 Jun 2017 07:40:41 GMT

{<Date={'>=$(=StartYear(Today()))'}>}

Assuming Your format date is DD/MM/YYYY or MM/DD/YYYY

sasiparupudi1 — Fri, 09 Jun 2017 12:59:11 GMT

Count(

{<DateField={'>YearStart(today(2)) <Monthend(today(2),-1)'}>}

YourFlag)