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.

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 
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

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

Contributor III
Contributor III

Thankyou Lisa! thats the solution