Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

KPI and Filter Pane

Hi all,

In a sheet i have 2 KPI which displays the counts of invitations, 1 KPI displays counts invitations of all clients and other displays the count of selected clients.

1. KPI - Count(Invitation_id)

2. KPI - count({$<client_id={'1','2','3','4'}>}invitation_id)

I have added the filter pane with client_id when i tried to filter for client_id = 1. then the value changes only in 1st KPI but not in second KPI.

How can i have chnages in second KPI when client_id is selected in Filter pane.

Regards,

Kumar

Tags (1)
1 Solution

Accepted Solutions
stalwar1
Not applicable

Re: KPI and Filter Pane

Try this for second KPI

Count({$*<client_id={'1','2','3','4'}>}invitation_id)

1 Reply
stalwar1
Not applicable

Re: KPI and Filter Pane

Try this for second KPI

Count({$*<client_id={'1','2','3','4'}>}invitation_id)