Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year?

Hello,

How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year?

I have two fields, OrderDate which has all the dates for all the years (including this year and last year)

and my Sales field has the sales values.

How can I write set analysis which analyses like for like sales this year and last year.

It will be a Line Chart with the Dimension as Month (which is coming from the OrderDate field)

1 Solution

Accepted Solutions
1 Reply
giakoum
Partner - Master II
Partner - Master II