Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Search instead for
Did you mean:
Contributor

## CYTD vs LYTD comparison

Hello everybody,

For my case i need to  compare current YTD vs Last YTD.

I tried this solution in my Case but it doesn't work for my case.

YTD

Sum({\$<[Date] = {'>=\$(=YearStart(Today()))'}>} [Sales])

YTD Previous Year

Sum({\$<[Date] = {'>=\$(=Date(AddYears(YearStart(Today()),-1)))<\$(=Date(AddYears(Today(),-1)))'}>} [Sales])

YTD YoY Variance

(Sum({\$<[Date] = {'>=\$(=YearStart(Today()))'}>} [Sales]) - Sum({\$<[Date] = '>=\$(=Date(AddYears(YearStart(Today()),-1)))<\$(=Date(AddYears(Today(),-1)))'}>} [Sales]))

What informations do you need to  help me to solve it please ?

Labels (4)

• ### Visualization

2 Replies
Partner Ambassador/MVP

In this case, your set values should be in double quotes.

Sum({\$<[Date] = {">=\$(=YearStart(Today()))"}>} [Sales])

-Rob

Contributor
Author

HI,

thanks a lot for your quick answer, i tried it with the quotes and it didn't work.

If you need more informations about my case please feel free to ask.

Yass