Qlik Community

Qlik Education Documents

Documents related to Qlik Education.

YTD Calculation by Month

djsampat
Contributor II

YTD Calculation by Month

Calculated YTD using the selected Month with a Graph comparing the Month by Account to the YTD Sales value.

Attachments
Comments
Luminary
Luminary

Hi,

Best to use set analysis for better performance and change the expression to

= sum({1 <MonthId={"<=$(vMonthId)"}> }Sales)

Cheers

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-11-06 12:53 AM
Updated by: