Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I got a KPI like:
count({<Date = {'08.01.2021'}>}distinct %calllogs_PKEY)
I want it not to change, when the user selects values in the Date dimension. However if he selects like 2022, Qliks default functionality will make my KPI 0, because the 8.1.21 is not part of the currenlty selected year 2022. How can I fix this?
Best
Add e.g. {< Date = {'08.01.2021'}, Year = >}. You can add as many fields as you want.
If you want to ignore all selections on all fields, use {1< Date = {'08.01.2021'} >}