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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

Hi

I want to use set analysis for FTD,MTD,YTD calculations.

If anybody can provide script for this,would be great !

Regards

Praveen

1 Reply
Not applicable
Author

Hi Praveen,

Below code will help you to do the requirement.

MTD = sum({$<Month_Year={"$(=monthname(today()))"}>} Sales)

YTD = sum({$<Fin_Year={"$(=(yearname(today(),0,10)))"}>} Sales)

Regards

SridharYes