Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Contributor III
Contributor III

Compare sales

Hy everyone,

I have a question. I have a mastercalender and i want to compare sales (this year Vs. Previous year). I have a YTD (this and previous year) but I dont want to compare sales from januari until now but from march until now. How can i do that? (Without just using the filter pane).


2 Replies
Lisa_P
Employee
Employee

Hi Willem,

Set analysis would be the best solution.  You could limit based on quarter or month, not sure of your field names, but something like this ..

     Sum({$<CYTD={1}, Month={">3"}>}Sales) for this year

     Sum({$<LYTD={1}, Month={">3"}>}Sales) for last year

as your expressions for each measure

thewillemzelluf
Contributor III
Contributor III
Author

Thankyou Lisa! thats the solution