Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

magdalena123
New Contributor III

Measure based on the not selected filter_in Qlik Sense

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

2 Replies
arvind_patil
Valued Contributor II

Re: Measure based on the not selected filter_in Qlik Sense

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

magdalena123
New Contributor III

Re: Measure based on the not selected filter_in Qlik Sense

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