Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thewillemzelluf
New Contributor II

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
Employee
Employee

Re: Compare sales

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
New Contributor II

Re: Compare sales

Thankyou Lisa! thats the solution

Community Browser