Measure based on the not selected filter_in Qlik Sense

[magdalenatudose]

Hi, How can I make a measure based on the not selected filter in Qlik Sense? In my expression formula appear an filter/dimension that is not selected, but I need to use it, selecting other filter. Thank you, Magdalena

[arvind_patil]

Hi Magdalena,

You can achieve  this with the help of set analysis like  if you not select year 2017 but you require value of that year you can achieve as follows:

Sum({<Year={'2017'}>}Value)

if in more detail please provide sample data

Thanks,

Arvind Patil

[magdalenatudose]

Hi Arvil,

Thank you for your help!

How can I do this with my measure:

SUM(IF([F1]='Date1', IF([F2]='Date2', IF([F3]='Date3', [Val1]*[Val2]))))

My filters dates are: [F1], [F2], [F3]. I don't want to press filter 'Date2', but the expression be OK.

Thank you,

Magdalena