Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jigonzalez
New Contributor III

Set Analysis

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.

1 Solution

Accepted Solutions

Re: Set Analysis

May be this

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

6 Replies

Re: Set Analysis

May be this

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

jigonzalez
New Contributor III

Re: Set Analysis

Do you know something about DAX??

Re: Set Analysis

DAX? Not sure what that is?

jigonzalez
New Contributor III

Re: Set Analysis

A programming language for Power BI

Re: Set Analysis

Nope, no idea sorry

jigonzalez
New Contributor III

Re: Set Analysis

Ok, thanks for all

Community Browser