Link KPIs to a single sheet with different filters

[MatheusC]

I created this article with the intention of helping with a post, but also to collaborate with other similar questions that may be useful in the article.

Link KPIs to a single spreadsheet with different actions:

Resolution

Step 1 - KPIs

1st - KPI

Count({<Age={">30"}>}Name)

2nd - KPI

Count({<Age={"<=30"}>}Name)

3rd ......

Step 2 - Button
*The KPI itself may already contain a link to a spreadsheet, but since we would need to use the filter actions, I also centralized this navigation in the button chart.*

• Button for KPI 1

Action: Select values matching search criteria

Field: Age

Value: fx

='>30'

Add action:
Navigation (go to a Sheet)

Sheet: select the folder name

• Button for KPI 2

In this scenario, it follows the same procedure as the first, only changing the value that goes in the expression. '<='

Value: fx

='<=30' 

Note: If needed, you can add an additional action to clear the filter and ensure that only the current filter is filtered.

Final Step 3 - Container Layout

See how a small customization using the Layout Container chart can help maintain a cleaner look by inserting the button chart into the KPI as a simple icon.

This step will allow you to improve the design of your application, as you can organize your charts in a way that better suits your needs,
among several other features. So, explore:

- Here is the qvf file for import, you can also find a sample video. I hope everyone is doing well. Best regards, Matheus

Environment

• Qlik Sense SaaS