topic Re: YTD vs LYTD Expression in QlikView

YTD vs LYTD Expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I have been having some trouble generating an expression that outputs a percentage comparing YTD sales to LYTD sales. Currently my expression is comparing jan-dec 2016 sales to jan-sept 2017 sales, and I would like it to compare jan-sept 2016 and 2017. Please let me know if you need any clarification. My current equation is provided below.

=IF(sum( {$<Year = {$(#=Only(Year)-1)}>}[Total Sales])=0,'N/A', Round((sum([Total Sales])/sum( {$<Year = {$(#=Only(Year)-1)}>}[Total Sales])*100)-100,0.01) & '%')

Thanks!

Re: YTD vs LYTD Expression

kaushiknsolanki — Mon, 30 Oct 2017 15:28:14 GMT

You can try below expresion.

=IF(sum( {$<Year = {$(#=Only(Year)-1)}>}[Total Sales])=0,'N/A', Round((sum([Total Sales])/sum( {$<Year = {$(#=Only(Year)-1)},Month = {"<=$(=Max({<Year = {$(#=Only(Year))}>}Month))"}>}[Total Sales])*100)-100,0.01) & '%')

Regards,

Kaushik Solanki

Re: YTD vs LYTD Expression

Anonymous — Mon, 30 Oct 2017 15:42:52 GMT

Had to change 'Month' to '[Period Num]' and it worked. Thank you!

Re: YTD vs LYTD Expression

kaushiknsolanki — Mon, 30 Oct 2017 15:45:22 GMT

Great.

Regards,

Kaushik Solanki