Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
ArviAravind
Contributor
Contributor

Alternate state

I have 3 filter and two KPI chart. 

1. First filter of alternate state as "inherited" is Common for both the KPI chart. 

2. Second filter is dedicated to 1st Kpi chart of alternate state as State1. 

3. Third filter is dedicated to 2nd kpi chart of alternate state as State2

And a KPI chart of expression: Count(distinct TicketID) 

How do I brinng

1.both 1st filter and 2nd filter selection in 1st kpi chart 

2.both 1st filter and 3rd filter selection in 2nd kpi chart

And most importantly

no association is happening between filters. 

How can I achieve this??? 

 

@Michael Tarello

2 Replies
Michael_Tarallo
Employee
Employee

*BUMP* - Can someone please look at this?

Regards,
Mike Tarallo
Qlik
Don_Stocks_
Contributor III
Contributor III

KPI # 1: 

Count({$* State1}distinct TicketID)

KPI #2:

Count({$* State2}distinct TicketID)

Assumptions:

1. The first filter is inheriting the default state

2. You want to count the TicketIDs that are present in both States as opposed to counting those that are present in either (if you want the later then you would use ' + ' as the set operator between the states rather than the  ' * ' )

Don Stocks