Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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

Highlighted
Creator
Creator

Re: Help with Set Analysis - 13 months previous

Genius Smiley Very Happy Thanks Sunny