Qlik Community

Qlik Sense Deployment & Management

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

denisetrujillo
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.


hic

2 Replies
Digvijay_Singh
Honored Contributor III

Re: set analisys

May be this -

if(getselectedcount(Year)=0,

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

     sum(Sales)

)

denisetrujillo
New Contributor II

Re: set analisys

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

Community Browser