Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
arusiva89
Contributor III
Contributor III

QTD Calculation

 I want to build the QTD logic by accumulating the MTD values..MTD values are stored in the QVD..I want to fetch the month end of each month (Say for example - for Q1 2021- Jan 31,Feb 28,Mar 31 values should be added for QTD).How can I achieve it with existing QVD which has MTD values .I want to populate the values from backend only.Any ideas/suggestions ?

Existing QVD 

Country Date Sales

A,2021-01-01,100

A,2021-01-02,200 (MTD values - Accumulation of 1st & 2nd of Jan)

..

..

A,2021-01-31,150000 (MTD values)

 

Expected QVD:

Country Date Sales

A,2021-03-31,10000000 (Sum of Jan 31+Feb 28+Mar 31 value)

Labels (2)
2 Replies
dineshm030
Creator III
Creator III

=Sum({<Quarter = {'Q1'}>}Value)

arusiva89
Contributor III
Contributor III
Author

I need it in backend script