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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Nagaraju_KCS
Specialist III
Specialist III

Need Help??

Hi Community,

Calculate Sales history by month for last six month.

Thanks..

5 Replies
venkatg6759
Creator III
Creator III

sum({<month={'>=$(=monthstart(addmonths(today(),-6)))'}>}Sales)

Nagaraju_KCS
Specialist III
Specialist III
Author

Hi Venkat,

it's not working. i want based on current selection.

suppose if i am click Dec2013,  i want to show last 6 months...

MK_QSL
MVP
MVP

what is you selection format?

It is MMM or MMMYYYY or MMMYY or...???

venkatg6759
Creator III
Creator III

Check the sample attachment

Not applicable

instead of today you can use max(month).