Help with Set Analysis - 13 months previous

chris1987 — Sat, 16 Nov 2024 04:38:32 GMT

Hi,

I'm trying to use a simple set analysis function to return a figure from 13 months ago.

I have a master calendar with "MonthID" and just need to return the sum of LineInvoiceAmount.

Here's what I thought would work:

=sum({<[MonthID]={"=(only({1<DateID={'$(=num(date(today(1))))'}>}[MonthID] )-13)"},Description=>}LineInvoiceAmount)

I can enter :

"=(only({1<DateID={'$(=num(date(today(1))))'}>}[MonthID] )-13)"

into a text box and return the correct MonthID and I can filter on that MonthID manually and return the correct results, but I can't seem to get the function to work.

Any help wold be appreciated

Cheers

Chris

Re: Help with Set Analysis - 13 months previous

sunny_talwar — Mon, 28 Jan 2019 13:47:34 GMT

Try this

=Sum({<[MonthID] = {"$(=Only({1<DateID = {'$(=Num(Today(1)))'}>}[MonthID]) - 13)"}, Description>} LineInvoiceAmount)

Re: Help with Set Analysis - 13 months previous

chris1987 — Mon, 28 Jan 2019 13:52:15 GMT

Genius Thanks Sunny

topic Help with Set Analysis - 13 months previous in QlikView

Help with Set Analysis - 13 months previous

Re: Help with Set Analysis - 13 months previous

Re: Help with Set Analysis - 13 months previous