Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alemberg
New Contributor II

Display N/A until

Is there a way to have a KPI display as N/A until a user select something from either a dropdown or within another visualization. As an example Total Returns N/A until the user selects a specific Fund or Region

1 Solution

Accepted Solutions
MVP
MVP

Re: Display N/A until

May be like this:

If(GetSelectedCount(Fund) = 0 and GetSelectedCount(Region) = 0, 'N/A', Expression)


UPDATE: You might need to play around with the Formatting of the KPI though

1 Reply
MVP
MVP

Re: Display N/A until

May be like this:

If(GetSelectedCount(Fund) = 0 and GetSelectedCount(Region) = 0, 'N/A', Expression)


UPDATE: You might need to play around with the Formatting of the KPI though