Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-09-23 09:22 AM

PERIOD Display

Hi there,

A user asked me to display in one table, SALES for the current month and SALES for the previous THREE months.

With Dimensions being the "CAR MAKE", "MONTHS" and then one expression "SALES COUNT". I have tried using variables and the AddMonths function etc, but it's not working.

How can I achieve this?

Regards.

308 Views
0 Likes
2 Replies
Not applicable
‎2013-09-23 09:31 AM
Author

Do you want the sum of the sales for the previous 3 months?  If so, then use rangesum

rangesum(below(total sum(sales),1,3))

239 Views
0 Likes
MayilVahanan
MVP
MVP
‎2013-09-23 09:38 AM

Hi

Try like this

http://community.qlik.com/docs/DOC-4252

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
239 Views
0 Likes