Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD MTD QTD in single expression

Hi Friends,

I got a requirement like,there is straight table which shows sum sales,but whenever any year is selected then it will show data for

last year+current year which I already get,but whenever any quarter or month is selected then it will sum the sales till that quarter or till that month.

but everything is in single expression.may be it is easy but I didnt able to find the correct way please anyone help me out in this for practice find the sample in attachment.

Thanks & Regards

Bhawna

1 Reply
Not applicable
Author

any suggestion friends...