Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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