topic Re: expression in QlikView

expression

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

HI All,

Expertise please havea look .

i want to get from today to back 2 years ..

is this correct expression ..

count({<[Dept T]={'A'},PaidDate={"$(=Max(PaidDate))"}>} ID),

Count({<[Dept T]={'A'},PaidDate={"$(=Max(PaidDate)-1)"}>} ID)/12,

Count({<[Dept T]={'A'},PaidDate={"$(=Max(PaidDate)-2)"}>}ID)/12)

if this is wrong then please correct ..

and the output should be like the way shown in screenshot

Thanks in advace

Anil_Babu_Samineni — Mon, 13 Nov 2017 05:47:47 GMT

You can try with. First try in text object using 2 diff expressions and then have a look in report

count({<[Dept T]={'A'},PaidDate={">=$(=AddYears(Max(LoadDate),-2)) <= $(=Max(LoadDate))"}>} ID)

vikasdesai — Mon, 13 Nov 2017 07:32:22 GMT

Hello

Use following Expression

count({<[Dept T]={'A'},PaidDate={">=$(=Yearstart(Max(LoadDate),-2)) <= $(=Max(LoadDate))"}>} ID)