Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

New Contributor II

set analisys

Hello everyone,

I need your support, I want to use the set analisys. in my graphics I need to add the sales according to the selected year; but if the year is not selected, add the sales of the maximum date.

how can I do it

I am using
sum ({<[Year] = {'$ (= year (max (Date)))'}>} Sales) but when you want to select two years in my filter, you do not add them to me.


2 Replies
Honored Contributor III

Re: set analisys

May be this -


     sum ({<[Year] = {'$ (= year (max (Date)))'}>} Sales),



New Contributor II

Re: set analisys

Thanks for your support, his answer helped me a lot.

Community Browser