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
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:
if in more detail please provide sample data
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.
Retrieving data ...