Solved: Re: Set Analysis - Qlik Community

Anonymous · ‎2018-02-06

I will have to do that. I'm trying do a comparison of products, where I need to find my most sold product that wasn't sell the previous year.

sunny_talwar · ‎2018-02-06

May be this

Sum({<ProductName = {"$(=FirstSortedValue({<ProductName = e({<Year = {$(=Max(Year) - 1)}>})>}ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}>}sales)

View solution in original post

sunny_talwar · ‎2018-02-06

May be this

Sum({<ProductName = {"$(=FirstSortedValue({<ProductName = e({<Year = {$(=Max(Year) - 1)}>})>}ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}>}sales)

Anonymous · ‎2018-02-06

Do you know something about DAX??

sunny_talwar · ‎2018-02-06

DAX? Not sure what that is?

Anonymous · ‎2018-02-06

A programming language for Power BI

sunny_talwar · ‎2018-02-06

Nope, no idea sorry

Anonymous · ‎2018-02-06

Ok, thanks for all