Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Help with Set Analysis - 13 months previous

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

 

1 Solution

Accepted Solutions
Highlighted

Re: Help with Set Analysis - 13 months previous

Try this

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

View solution in original post

2 Replies
Highlighted

Re: Help with Set Analysis - 13 months previous

Try this

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

View solution in original post

Creator
Creator

Re: Help with Set Analysis - 13 months previous

Genius Smiley Very Happy Thanks Sunny